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

Archives: October 2010

When is that Restore Going to Finish?

I spent a good portion of last weekend restoring databases from backup due to a large release. Nothing went wrong, luckily, but I was practicing in case something did. It goes without saying that I spent a ton of that time sitting in front of my PC wondering when the… Read more

0 comments, 770 reads

Posted in Adventures in SQL on 27 October 2010

Stop Forgetting the DAC

From time to time I hear of DBAs that had to restart the SQL Server service on a 2005 or 2008 server because it had stopped accepting new connections. The thing is that most times those servers did not have to be restarted. If the DBA had logged in via… Read more

4 comments, 844 reads

Posted in Adventures in SQL on 6 October 2010

How Do I Spot Identity Columns That Are About to Max Out?

Every so often, usually in the middle of the night or on a holiday weekend, an identity column will hit the maximum size for it’s data type and stop allowing new values to be inserted into the table. It goes without saying that an identity column with enough activity to… Read more

1 comments, 469 reads

Posted in Adventures in SQL on 5 October 2010