Monthly Archives: December 2014

Albuquerque SQL Saturday

I’m excited to announce that I’ll be presenting “Fast and Furious Dynamic SQL” at SQL Saturday #358 in Albuquerque on February 7th, 2015. This will be my first time as a PASS presenter, so please save your best heckling and … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

Viewing the Plan Cache

I’m working on a script and wanted to know how SQL was caching the query plan. So I wrote this little snippet. The only real value I’m adding here is getting the XQuery correct to pull out the SQL itself. … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Robinson’s Law

I coined this a while back. I just came across it again, and thought I’d share it. How many of us know this to be true? “An otherwise inexplicable bug will become easily apparent to the programmer who caused the … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Pages Used

One of the items in my toolbox is this simple query that returns the number of pages used by different tables in the database. The nice thing is that it gives one simple number that includes indexes, lob data – … Continue reading

Posted in Uncategorized | Tagged | Leave a comment