Tag Archives: AskSSC

Bulk Restores – response to a question on Ask SQLServerCentral

Posted on January 24, 2013 by

Here’s the scenario: You’re rebuilding a DR environment, and have a set of Full, Differential and transaction log backups to restore. How to script this to run with minimal interference? The Approach Assumptions: All your backups are in subdirectories named … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , | Leave a comment

Index Maintenance for SQL2k

Posted on July 29, 2011 by

Once again, the “smart indexing in SQL2000″ question has raised its ugly head on AskSSC.  Those of you in SQL2005 and above have the opportunity to use some fine index maintenance scripts from Ola Hallengren and Michelle Ufford (among others, … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , | Leave a comment

Deduplicating data with a CTE

Posted on July 27, 2011 by

Typical.  You answer a question only to find that the answer you provided isn’t what the original poster was looking for by reading the dozen or so comments that arrived on the question while you were figuring out your answer… … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | 2 Comments

T-SQL Tuesday #014 – New Year’s Resolutions

Posted on January 11, 2011 by

T-SQL Tuesday this month is hosted by Jen “MidnightDBA” McCown, (blog|twitter) blogger, twitterer, and one of MS’s most recent MVPs.  Congrats, Jen!  The subject for discussion is “Resolutions”. Not “New Year’s Resolutions”, but that’s what I’m going to be looking … Continue reading →

Posted in SQLServerPedia Syndication, T-SQL Tuesday, Uncategorized | Tagged , , , | 1 Comment