Next PASS Summit is Nov 6-9, 2012

After enjoying the entirely reasonable weather in Seattle in October this year we’ll return to our more traditional time frame...

No longer just an admin but a DB Astronaut : A poem.

Today we have a guest post from Phil Factor as Brad is on vacation.
‘ I used to fettle databases as...

October 2011 SQL Server 2012 Diagnostic Information Queries

Since Microsoft released the official name for “SQL Server Code Named Denali” last week at the PASS 2011 Summit, it...

Query Memory Spills

When you sometimes look at Execution Plans, you can see that the SELECT operator has
sometimes a so-called Memory Grant assigned....

RSS Tuning Whitepaper notes and clarifications

This morning this caught my eye on SQLServerCentral.com: Maximizing SQL Server Throughput with RSS Tuning(it came with a catchy SQLCAT...

SQL Server – Moving table with LOB data to different file group

Last week, i posted about moving tables to different file groups by recreating indexes. However, this method does not *work*...

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...