Browse by Tags

All Tags » Best Practice » General Tuning (RSS)
09 September 2010 22:25

Don’t add that column

This is the first of the topics from my presentation “ Gone in 60 nano seconds “   As a quick summary this is why additional columns can cause degraded performance. Background I put this brief list of points together after having a carefully tuned...
Posted by GrumpyOldDBA | with no comments
Filed under: ,
16 June 2010 20:15

So which null equals this null, that null? maybe this null, or is it this null?

Tuning takes many routes and I get into some interesting situations and often make some exciting finds, see http://sqlblogcasts.com/blogs/grumpyolddba/archive/2010/05/17/just-when-you-thought-it-was-safe.aspx for an example. Today I encountered a multitude...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
27 December 2006 11:06

NTFS Fragmentation - Bad for Databases ?

( Note: I had a couple of attempts to post this before I figured out how to publish pictures ) So what has this to do with the DBA you might say? Well I mostly make my living from tuning databases and applications. I always start with a hardware audit...
Posted by GrumpyOldDBA | 2 comment(s)
Filed under: ,