Tag Archives: AskSSC

Bulk Restores – response to a question on Ask SQLServerCentral

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

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

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

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