Stop PIPA & SOPA

I’m not going to black out my blog, because, let’s face it, who’s going to notice? But for all six...

Update Statistics and the new TraceFlag 2371

What comes first, the chicken or the egg? What happens first – update statistics or re-compilations?

The Statistics life cycle
As a regular...

When Date Modified changes for Sql mdf/ldf files

*This is related to physical file size of a MDF or LDF file not internal allocation.
One of our user asked...

Why It’s Called a User Group…

On Tuesday night was the first meeting for PASSMN, the SQL Server User Group in Minneapolis/St. Paul this year.  As...

#SQLThursday is here

Struggling to source quality free content on SQL Server? Finding it difficult to fill the void between #TSQL2sDay and Un-SQL...

A Trio of Functions

I found myself perusing an execution plan the other day.  I know, big surprise there.  This execution plan showed me some interesting things I had never really paid much...

A Trio of Functions

I found myself perusing an execution plan the other day.  I know, big surprise there.  This execution plan showed me...

ColoradoSQL for January 2012

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

CTE command In Sql Server

Common table expression (CTE):- Common table expression or CTE can be described as the temporary, named record set return by...

Eliminating Successful Backup messages with Powershell and SMO

As a DBA, I enjoy knowing that the better job I do, the less likely it is that any of...