2018-06-05 (first published: 2018-01-11)
2,168 reads
Scripts
SQL Server Backup, Integrity Check, Index and Statistics Maintenance
Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017.
2018-06-04 (first published: 2008-02-23)
48,105 reads
2018-05-30 (first published: 2018-01-03)
2,500 reads
2018-05-02 (first published: 2018-04-17)
1,023 reads
2018-05-01 (first published: 2018-04-20)
1,162 reads
Script out EXISTING database mail profile's settings
Script out EXISTING database mail profile settings
2018-04-25 (first published: 2018-04-23)
34,119 reads
Generate Large Amount of Data For Performance Testing
Generate large sample data for your performance and other uses
2018-04-24 (first published: 2018-04-18)
2,507 reads
Flexible Statistics Update
Update the statistics starting from most accessed and modified ones, with a time limit. Procedure will exit when @MaxExecutionTime parameter is greater than the current execution time.
2018-04-19 (first published: 2018-04-16)
516 reads
2018-04-19 (first published: 2018-04-12)
4,158 reads
Finding table name based on a specific value
This script is used to Find out the table name and column name where a specific string has been used
2018-04-17 (first published: 2018-04-13)
1,777 reads
Blogs
Local LLM Models at SQL Saturday Boston 2025
By Steve Jones
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...
3 things you must do to start data quality management right
As a data & AI strategist who’s seen countless projects succeed and fail, I...
Set Theory vs. Batch Mode in SQL Server
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
Forums
SSC Website Deployment 24 Sept 2025
We are planning on a fairly big code deployment to set the stage for...
Timeout when expanding the table
Experts, I am hoping to get some help and feedback. I have a server...
Single User SQL Server on Linux
Comments posted to this topic are about the item Single User SQL Server on...
Question of the Day
Single User SQL Server on Linux
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers