Using sys.dm_exec_requests to find a blocking chain

A query that calls sys.dm_exec_requests and pulls the statement text out of the request is a handy script for any DBA's...

We Are Community

Today I was planning on writing a summary post of PASS Summit experience but something happened last night that caused...

AWE has removed from SQL server 2012

AdvertisementsAWE has removed from SQL server 2012

AWE has removed from SQL server Denali onwards. Say bye bye to 32 bit...

ColoradoSQL. in October

All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...

Dropping a database – such a simple thing!

G’day,
I think it’s a safe bet that everybody here has issued a DROP DATABASE statement and knows what to expect.
Well,...

October 2011 LV UG Meeting Update

This is a republish due to a last minute change!!!
We had to reschedule the October meeting due to unforeseen circumstances....

October 2011 LV UG Meeting Update

This is a republish due to a last minute change!!! We had to reschedule the October meeting due to unforeseen circumstances.  The only change is the date of the...

October 2011 SQL Server 2008 Diagnostic Information Queries

Since Microsoft has been so busy releasing Cumulative Updates for both SQL Server 2008 and SQL Server 2008 R2 over...

PASS 2011 Recap

Last week was the PASS Summit in Seattle (again, but only for 1 more year) and I was up there...

Rat Sues Corn! Rather, rat accuses corn of thought-theft! Or something!

Note: I will be updating this post with, er, updates as I get them…
We’ve had our fair share of plagarists,...