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,265 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)
24,257 reads
SQL Server Cloud Migration Part I
A SQL Server migration with minimal business impact while synchronizing schema and data.
2013-09-23
3,332 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
6,782 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,724 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,041 reads
Blogs
Your First Jupyter Notebook
In April, I said I was going to start learning Jupyter Notebooks. It’s November....
Using Visual Studio Code
I’m a creature of habit. I have my routine when I get to my...
Docker Containers and Persistent Data
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
The Conference Springboard
Comments posted to this topic are about the item The Conference Springboard
Missing Data
Comments posted to this topic are about the item Missing Data
Ask SSC