The Case of the Shrinking CFO, err Database
Shrink SQL Server databases quickly and with virtually no contention.
2017-12-25 (first published: 2015-08-17)
4,287 reads
Edward Polley
Hidden Tricks To SQL Server Table Cleanup
How to delete millions of rows with virtually no contention.
2015-09-04 (first published: 2013-03-06)
27,144 reads
SQL Server Cloud Migration Part I
A SQL Server migration with minimal business impact while synchronizing schema and data.
2013-09-23
3,351 reads
Super Fast Transactional Replication Repair
Your production SQL Server transactional replication just failed and the business impact is critical. How do you get replication restored in minutes?
2013-05-30
7,796 reads
The Trouble with Transactional Replication and large articles.
This article will show you one way to quickly restore SQL Server replication with huge tables.
2012-05-18
7,274 reads
Large table cleanup with minimal locks
How do you delete millions of rows with minimal impact to the business? This article gives you a way to accomplish the removal of old data.
2012-03-06
14,931 reads
Blogs
Daily Coping 28 Jun 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Creating a Database Audit Specification can create new users & schemas in the background
I love database audits. They are simple, easy to use, effective, not overly resource...
Alert Filtering in SQL Monitor
By Steve Jones
SQL Monitor has improved a lot over the last couple of years. We have...
Forums
Returning To An Employer
Comments posted to this topic are about the item Returning To An Employer
SQL Server Collation
Comments posted to this topic are about the item SQL Server Collation
Replace calendar table multiplier column with date logic
Hello All, It's been a while. See the DDL/DML. I have a multiplier field...
Ask SSC