Welcome to Megan’s Space at Far2Go.net. You’ll find a brief introduction to me and this website here.
The LookupCTE trick described here is pretty slick. These days I find myself working with large databases where these things really matter and I found this post quite interesting.
No kidding: “One thing I have learned about Microsoft SQL Server is that regardless of your years of experience with the product or any given part of it clustering, SSIS, etc., there is always something left to learn – even things that in retrospect seem obvious well, duh! were new at some point, and there is always – always – something left out there waiting for you to discover.”
Clever. I don’t think I had ever heard of EXCEPT.
A nice, clear presentation. I am probably going to be starting with MVC soon, and this article made a lot of sense to me.
Here we go with developers again. I wonder if the ones that go around creating this particular kind of mess are also the ones that tend to flunk the index/performance quiz?
Well at least I “passed” (4 out of 5). Hint: read the questions CAREFULLY.
Never thought of this:
What does this have to do with database development? Ever work on a project where people were afraid to talk about what they saw going on? It’s an interesting book, to say the least, and it brings together in one place many “pieces of the puzzle” that I have encountered over the years.