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,302 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,511 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,891 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,337 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,074 reads
Blogs
Daily Coping 31 Jan 2023
By Steve Jones
Today’s coping tip is to take a small step towards and important goal. One...
Tales From The Field Weekly Wrap Up for the Week of 01-23-2022
By SQLBalls
Hello Dear Reader! It's been a while since I had time to sit down...
CONCAT_WS Function Truncates Text
I was writing some dynamic SQL that generates some SQL statements to load my...
Forums
'DATE' is not a recognized built-in function name
Please assist. I am getting the above error: CREATE VIEW DailyAccountBalances AS SELECT DATE(TransactionDate)...
SSIS Sort Alphanumeric?
Hello, I'm pretty new to SSIS, but I have an Excel source that I...
How to get number of unique months from table
Hi guys, I want some help with a code to count the number of...
Ask SSC