2009-07-08 (first published: 2009-06-25)
1,185 reads
Scripts
Drive space checking monitoring procedure
This procedure can used to monitor the disk drive space details and we can set threshold and it can be enhanced to send an alert incase of reaching the threshold.
2009-07-07 (first published: 2009-06-23)
2,200 reads
2009-07-06 (first published: 2009-06-23)
4,957 reads
Estimating the table size...
This is an effort to program the "Estimating the Table size" section given in BOL.
2009-07-06 (first published: 2009-06-19)
1,806 reads
SQL 2000: Track Stored Procedure Changes
SQL Server 2000 does not log the procedures modified using ALTER statement. Here's the script to find out the same.
2009-07-06 (first published: 2009-03-02)
1,291 reads
Script to find latest backups for all databases
If you are not the only one who takes care of the backups, knowing the backups taken recently is very crucial for a production DBA.
2009-07-01 (first published: 2009-06-19)
2,357 reads
Splitting the string with unique delimiter.
The statement is splited into columns according the delimter and it has been captured in the table datatype.
2009-06-29 (first published: 2009-06-22)
1,203 reads
The Automated DBA: Batch Database File Grower - SQL 2000 Version
Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.
2009-06-25 (first published: 2009-06-08)
601 reads
The Automated DBA: Batch Database File Grower - SQL 2005 Version
Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.
2009-06-23 (first published: 2009-06-08)
1,213 reads
The Automated DBA: Batch Database File Grower - SQL2005 ReportOnly Ver
Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.
2009-06-22 (first published: 2009-06-08)
1,061 reads
Blogs
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers