Tag Archives: sql server

When Did That Restore Finish?

Posted on July 28, 2011 by way0utwest

I saw this question come across Twitter under the #sqlhelp tag one day and was wondering myself. Someone suggested the default trace, I was thinking msdb.dbo.restorehistory and decided to check. First I hit Books Online. It notes that the restore_date … Continue reading →

Posted in Blog | Tagged , , | Comments Off on When Did That Restore Finish?

Time for a ROWID?

Posted on July 27, 2011 by way0utwest

One of the things I’ve been doing lately is looking forward to future versions of SQL Server. Not SQL 11/Denali, which has CTP 3 out now, but more towards the future. SQL 12 and beyond, and wondering how the platform can advance … Continue reading →

Posted in Editorial | Tagged | 2 Comments

Patches for SQL 10 and Techniques for SQL 11

Posted on July 25, 2011 by way0utwest

A little over a week ago saw a number of patches released for SQL Server, including the much awaited Service Pack 1 for SQL Server 2008 R2. While I wouldn’t caution people to wait for SP1 any longer when a SQL … Continue reading →

Posted in Editorial | Tagged | Comments Off on Patches for SQL 10 and Techniques for SQL 11

The Cost of Page Checksums

Posted on July 25, 2011 by way0utwest

What’s the overhead for a page checksum? I’ve seen various numbers thrown out, but I thought that Paul Randal had written at one point that it was around 1-2%. I can’t find a reference, but in this post, Paul doesn’t … Continue reading →

Posted in Blog | Tagged , | 1 Comment