Welcome to Megan’s Space at Far2Go.net. You’ll find a brief introduction to me and this website here.
Reply
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.
Improving Query Performance by using correct Search Arguments – SQLServerCentral.
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.”
via Backup Checksums and Trace Flag 3023 – SQLServerCentral.
Clever. I don’t think I had ever heard of EXCEPT.
Using EXCEPT to Determine Row Differences – SQLServerCentral.
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?
Fixing Cache Bloat Problems With Guide Plans and Forced Parameterization.
Well at least I “passed” (4 out of 5). Hint: read the questions CAREFULLY.
Never thought of this:
Using hash values in SSIS to determine when to insert or update rows.
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.