Convert Mirroring to Log Shipping
Describes how to convert database mirroring to log shipping in SQL 2005/2008.
2010-08-19
5,807 reads
Jeremy Egbert
Repair Corruption Using the Mirror Database in SQL 2005
Explanation of how to repair a database in SQL 2005 Enterprise which is mirrored.
2010-05-10
4,277 reads
Script to Compress Tables and Indexes
This script creates scripts to compress all tables and indexes in a database.
2010-01-04 (first published: 2009-12-11)
9,822 reads
Blogs
It’s 2021, so why are you reading this?
If you’re reading this, there’s a good chance you’re straight, white, male, and English-speaking....
Daily Coping 20 Jan 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
[Coping] Hidden Wounds
By Brian Kelley
Through high school and college, I carried deep wounds due to what was going...
Forums
Find unmatched between 2 tables using field as selection criteria
I have the following tables as a example. Table 1 EmpID, LastName, FirstName 1,Smith,John...
update using self-join - confirm it looks at old values
I'm doing an update using a self-join, and just want to confirm something. If...
Representative Data Challenges
Comments posted to this topic are about the item Representative Data Challenges
Ask SSC