SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: December 2010

Get Prepared for the January Hiring Season

Get Prepared for the January Hiring Season

As the year winds down, in what was undoubtedly a tough economic year for jobs all around, and in the IT sector, hope for 2011 comes as an early Christmas present.  Quiet is the word in these last two weeks of the… Read more

1 comments, 749 reads

Posted in Pearl Knows on 21 December 2010

Just in time for Christmas – SQL Server 2005 SP4

Just in time for Christmas, Microsoft releases SQL Server 2005 SP4.  

Many were wondering if they would meet their intended 4th quarter target date for its release, and indeed Microsoft has delivered.  It’s taken an entire two years (December 15, 2008 – December 17th 2010), almost… Read more

0 comments, 1,737 reads

Posted in Pearl Knows on 18 December 2010

Upgrading to SQL Server 2008 - a comprehensive checklist.


There are many considerations and much preparation to do, when a company decides that it is ready to upgrade their SQL Server to the latest version, as there may be several changes, feature deprecations, and new or improved features that can be leveraged.  It’s not always as simple… Read more

3 comments, 13,446 reads

Posted in Pearl Knows on 13 December 2010

Signal Waits and Resource Waits...a clarification


Signal Waits vs. Resource Waits

During my presentation at SQLSaturday#59, I spoke about the categories of wait types, such as Resource Waits, Signal Waits, External Waits, and Queue Waits.

So just to define them here, as I did in my session:

Resource Waits occur when a worker requests access… Read more

0 comments, 13,871 reads

Posted in Pearl Knows on 3 December 2010