SQL Server
Index-Index-Index-Index-GOOSE! (Part One) The always short, and occasionally humorous, Tim Ford dives into the statistics DMVs and returns with a good explanation of what they are and how to use them.
Suggested DBA Work Plan If you’re like me, you’re not a production DBA, yet. I’m an accidental DBA who became a development DBA who [...]
SQL Server
Missing Index Information and Query Stats Grant Fritchey put together a nice little query to pull XML query plans out of the DMVs. Thankfully, these plans can also tell use which indexes are missing
Scalar Functions vs. Table Valued Functions vs. Inline Code Aaron Alton does some testing on these three to determine which is [...]
Denis Gobo started up a new meme about your first computer and favorite games.
My first computer was a Tandy 1000SX with 640KB of RAM that my family got when I was 9 or 10, I think. My dad quickly overclocked it to an astounding 7.6 MHz of pure Intel 8088 power and added a 20 [...]
I recently became even more lazy than usual and was looking for a way to test all of my stored procedures (there are over 180 of them in my production database). Since we have a limited hardware and software budget, buying extra software isn’t a part of the equation. So, I took it upon myself [...]
