Tag Archives: sql server

Brent Ozar Blitz at SQL Server Connections

Posted on March 29, 2011 by way0utwest

The first session of the day for me was Brent Ozars Blitz talk on how to quickly get information on a new server. I have seen Brent’s video on this and read some of his blog posts, but i wanted … Continue reading →

Posted in Uncategorized | Tagged , , | Comments Off on Brent Ozar Blitz at SQL Server Connections

Locking and Blocking from Joe Webb – DevConnections

Posted on March 29, 2011 by way0utwest

Locking should be simple, right? You need to access a row or table and you get a lock. Oh yeah, blocking is bad. It’s not that simple, and I find this is an area that many people do not understand … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Locking and Blocking from Joe Webb – DevConnections

What Differentiates Enterprise?

Posted on March 25, 2011 by way0utwest

There seems to be regular disagreement from SQL Server professionals about what features are most important for future versions and which bugs should receive the highest priority. However one thing that many customers complain about is the lack of features … Continue reading →

Posted in Editorial | Tagged , | Comments Off on What Differentiates Enterprise?

Test Before Deciding

Posted on March 21, 2011 by way0utwest

Will a new index improve the overall performance of your database server? Will adding another index slow down your insert or update performance? Can adding another file to tempdb make things run quicker? The answer to all of those questions … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Test Before Deciding