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,269 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)
25,448 reads
SQL Server Cloud Migration Part I
A SQL Server migration with minimal business impact while synchronizing schema and data.
2013-09-23
3,340 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,168 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
6,903 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,351 reads
Blogs
Daily Coping 7 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Publish ADF from code to further environments
By Kamil
Struggling with #ADF deployment? adf_publish branch doesn’t suit your purposes? Don’t have skills with PowerShell? I have good...
Getting the Proc Code–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
Using azcopy to copy files
Im trying to copy the contents of my sql server backup .bak files to...
How to efficiently perform search on my DB and Word documents on my server?
So I'm building a system for a client and they want to have a...
Copy Azure SQL DB App data to Azure Synapse
Hello, I am looking for the best way to copy change data from my...
Ask SSC