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
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
A better way to use sp_spaceused, returning values on one row for the database instead of two.
2008-09-04
4,038 reads
A script that can generate a massive amount of data relatively quickly
2008-09-04 (first published: 2008-07-11)
1,312 reads
By Steve Jones
Today’s coping tip is to get back in contact with an old friend. This...
In terms of encryption, Key Rotation is the process of replacing your encryption keys...
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
Hello everyone!! I have this SQL statement: SELECT dateadd(year,(2023 - year(DH.DOC_DATE)),DH.DOC_DATE) AS 'Date', DD.STORE_CODE...
Hi, I have four views on one database to which one sql authenticated user...
Comments posted to this topic are about the item Schedule Jobs on a Clustered...