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,425 reads
SQL Server Cloud Migration Part I
A SQL Server migration with minimal business impact while synchronizing schema and data.
2013-09-23
3,333 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,838 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,749 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,062 reads
Blogs
Understanding Azure Geo-Redundant Storage
By John
While at PASS Summit 2019, I gave a session on designing Azure Disaster Recovery...
Prompt in ADS
By Steve Jones
Ever since VS Code and Azure Data Studio came out, people have been asking...
When Too Much is Not a Good Thing
Explore how to avoid unwanted results that oft occur due to lack of attention...
Forums
Restart cumulative totals to 0 at the change of subsets in a sql table.
I have a dataset that I want to track the number of cars, trucks,...
Azure DB newbie trying to locate existing Azure DBs
Hello, I've been tasked with trying to learn more about existing Azure DBs that...
BAckup history not showing into MSDB
Hello, We had an strange issue that our sql server 2012 Sharepoint Databases backup...
Ask SSC