Tag Archives: sql server

Searching for Plans

Posted on September 13, 2010 by way0utwest

I was re-reading Conor Cunningham’s “Does Join Order Matter?” recently and found this quote in the post that stood out. As an aside, read this post. It’s fantastic. “…SQL Server’s QP is actually not set up to give you the … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Searching for Plans

Instrumentation

Posted on September 10, 2010 by way0utwest

In a discussion recently someone mentioned that they built in timing mechanisms into their application so they were aware of how long certain modules or functions were executing. Using this data, they could easily determine if the system was performing … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Instrumentation

Common SQL Server Mistakes – GUID as a Clustered PK

Posted on September 8, 2010 by way0utwest

I haven’t been thrilled with GUIDs as primary keys, mainly because I think that it’s hard for humans to work with GUIDs. A GUID, or uniqueidentifier, looks like this:ECB6ECB4-ACCB-4382-84D1-19990D59CA2FNot exactly something I want to try and type or include in … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Common SQL Server Mistakes – GUID as a Clustered PK

Developer Deployment Frustrations

Posted on September 8, 2010 by way0utwest

Why don’t developers like SQL Server? Probably a few reasons, but I’m sure this is one that really frustrates them. I found a Connect Item that was titled:  Why is Deploying SQL Server 2008 R2 sooooo FRUSTRATING?!! There really is … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Developer Deployment Frustrations