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,261 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)
23,263 reads
SQL Server Cloud Migration Part I
A SQL Server migration with minimal business impact while synchronizing schema and data.
2013-09-23
3,330 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,236 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,511 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
13,891 reads
Blogs
Information Measurement with SQL Server Part 4.5: The Squared L2 Family of Distances
By Steve Bolton …………In the last two installments of this series of amateur self-tutorials...
Security Learning Pathway at PASS Summit.
This year PASS is trying something new at PASS Summit. There are going to...
Pathways to Progress
One of the most significant and hardest challenges we face as data professionals (or...
Forums
Help with a stored procedure
I have a table "Mytable" containing a list of IDs. There is a web...
Need to perform leaf level aggregation
So I have a DW with a table with some pre-aggregated scores (not my...
Migrating from (mostly) 2K8 to 2016
HI all, About to start this project and would be grateful for any good...
Ask SSC