The procedure below deletes all records from the specified database's(except master, model, msdb and tempdb) tables (except those from the schema 'sys').
2011-12-09 (first published: 2008-01-31)
4,213 reads
2011-12-08 (first published: 2011-11-23)
1,150 reads
This script validates the sufficient disk space per drive.
When you'll reach a minimum on a diskdrive, the script will mail all recipients.
2011-12-06 (first published: 2011-10-28)
4,070 reads
2011-12-01 (first published: 2011-11-09)
1,289 reads
This command is the equivalent of the LEFT() function (cumbersome but effective)
2011-11-29 (first published: 2011-11-14)
1,183 reads
ntext, text, and image (Transact-SQL). This script will alter the data type from image to
varbinary(max) which is very much required as the data type is out
of support.
2011-11-28 (first published: 2011-11-14)
880 reads
A SELECT statement which includes the alpha description of each job's schedule
2011-11-25 (first published: 2007-11-01)
4,573 reads
This creates a Tally or Numbers table which is frequently used to replace loops in code and is much faster than most loops.
2011-11-24 (first published: 2008-03-07)
6,709 reads
This script generates a audit trigger for each table in the database. The trigger then logs when each table is updated.
2011-11-23 (first published: 2008-05-09)
4,800 reads
2011-11-22 (first published: 2008-03-19)
5,897 reads
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
How I used AI for this postChatGPT to generate images based on info specifically...
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Comments posted to this topic are about the item How Can SQL Server Detect...
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers