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,275 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)
26,872 reads
SQL Server Cloud Migration Part I
A SQL Server migration with minimal business impact while synchronizing schema and data.
2013-09-23
3,345 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,694 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,159 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,807 reads
Blogs
Amazon RDS Custom for SQL Server – A new beginning
By AnupWarrier
Imagine getting SA (sysadmin) access to your RDS SQL Server Instance! Well, that was...
Getting Started with the Advent of Code as a #SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Your next step in the cloud
Over the last nine months I’ve presented (virtually) eleven times on a variety of...
Forums
Row limit for Updates before transaction log fills up
Hello SSC, I hope everyone is staying safe and healthy. I am using SQL...
Changing the Excel Rendering format???
JHi I was wondering if anyone knew how I can change the Excel rendering...
concat + isnull
hello How to get output below query ple any one Suggest me. i will...
Ask SSC