Checking fragmented indexes
A quick script to check for fragmentation in a database and generate a list of defrag statments you can run.
2008-09-24
2,422 reads
Monitor database growth - a better way for sp_spaceused
A better way to use sp_spaceused, returning values on one row for the database instead of two.
2008-09-04
4,038 reads
Quick and dirty way to make a very large table
A script that can generate a massive amount of data relatively quickly
2008-09-04 (first published: 2008-07-11)
1,312 reads
Blogs
New Job -> Week 2 -> Creating a Checklist
This is part of a series of new job blog posts. You can find...
SQL Server 2022 Administration Inside Out
By Will Assaf
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...
WIT/DEI Mental Health and Wellness Day Challenge to Present
Back in December 2019, I started presenting my session on mental health with lots...
Forums
SSIS C# Script Question
Hi everyone I am working on a SSIS package where I am automating data...
Review Early and Often
Comments posted to this topic are about the item Review Early and Often
SQL Agent jobs - script to get what jobs failed
I have been trying to find SQL that shows what SQL Agent jobs failed...
Ask SSC