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,309 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,734 reads
SQL Server Cloud Migration Part I
A SQL Server migration with minimal business impact while synchronizing schema and data.
2013-09-23
3,353 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,960 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,386 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
15,147 reads
Blogs
Using a tnsnames.ora file with the Microsoft Connector for Oracle in SSIS
One of the nice things about the Microsoft Connector for Oracle is that it...
ChatGpt Experiments–Getting Documentation
By Steve Jones
I get asked questions by salespeople all the time. Usually this is because a...
A New Word: Jouska
By Steve Jones
jouska – a hypothetical conversation that you compulsively play out in your head –...
Forums
partitioning a huge table
Hi folks I would like to get your views about partitioning a huge table...
SQL Website Development: A Comprehensive Guide to Building Dynamic Web Applicati
Introduction to SQL Website Development What is SQL? Importance of SQL in web development...
Ask SSC