Sql Stuff

I ran into an interesting scenario with a customer this past week that behaved a bit differently than I expected (not having ever verified the behavior before, or even considering it I guess) at first. After spending some time thinking about it, I think...

I spent this past week with a customer giving a workshop covering Sql 2000 architecture and performance related information (interpreting query plans, index structures, etc., etc.), and during the course of the week a few good points came to light that...

Similar to my post here ( http://blogs.msdn.com/chadboyd/archive/2007/03/11/what-indexes-are-used-most-often-or-least-often-on-my-server.aspx ) regarding index usage, you can use the following code below to get index operational information (exposed via...

Well, I'm now also presenting at the CMAP Code Camp the week following the NOVA CodeCamp, so, if you're in the Baltimore/DC area (or even NOVA and can't make the NOVA CodeCamp the week before), I'll be presenting at least the same 2 sessions at the CMAP...