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,416 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
Daily Coping 6 Feb 2023
By Steve Jones
Today’s coping tip is to get back in contact with an old friend. This...
Rotating a Certificate Used by TDE
In terms of encryption, Key Rotation is the process of replacing your encryption keys...
Daily Coping 3 Feb 2023
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
Forums
Group by issue
Hello everyone!! I have this SQL statement: SELECT dateadd(year,(2023 - year(DH.DOC_DATE)),DH.DOC_DATE) AS 'Date', DD.STORE_CODE...
Ownership chaining
Hi, I have four views on one database to which one sql authenticated user...
Schedule Jobs on a Clustered SQL Server
Comments posted to this topic are about the item Schedule Jobs on a Clustered...
Ask SSC