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,281 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,084 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,780 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,246 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,903 reads
Blogs
Storage Field Day 23 – HammerSpace
By kleegeek
I am thrilled to have been a part of this year’s Storage Field Day...
Daily Coping 16 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Why You (usually) Want a Clustered Index
By alevyinroc
Note: I originally wrote this a few years ago but never posted it. It...
Forums
Migration of Data from one Database to Multiple Databases
Hello, I have a requirement to migrate the data from existing AWS RDS DB...
AWS Beginner questions
I'm having some trouble wrapping my head around the relationship between EC2 instances and...
How to get weekly and Monthly view from daily in sql server
Hello All, I have a table like below. I need to get daily,weekly and...
Ask SSC