Tag Archives: AskSSC

Death of a Community, or RIP AskSSC

Posted on December 11, 2023 by thomasrushton

Ask SQLServerCentral is closing down on 11th December, for Reasons. When I started out as a full-time DBA back in 2010, it was the first Q&A site I found that was active, friendly, and easy to use. It differs from … Continue reading →

Posted in Uncategorized | Tagged | 3 Comments

Bulk Restores – response to a question on Ask SQLServerCentral

Posted on January 24, 2013 by thomasrushton

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 thomasrushton

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 thomasrushton

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 thomasrushton

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