Creating a DTS package with a Perl Script
This script uses the DTS object model to create a simple package, execute the package, and properly check for any errors.
2005-05-19 (first published: 2005-04-01)
266 reads
Scripts
HexToSmallInt
Hans asked if it could be faster. This is about 10% faster; not much. His is admittedly more readable, and mine will act very strangely with invalid hex digits.How does it work? I'm converting the string '1234' to the value 0x31323334 (for example), then subtracting '0000' so that it is 0-based in each byte (CONVERT(INT,0x30303030) […]
2005-05-16 (first published: 2005-05-04)
149 reads
SQL Blocking and Blocked Proc + Notifi - Part2
Based on the script by Paul Delmarche ( http://www.sqlservercentral.com/scripts/contributions/1482.asp ).Updated to now include the spid, username, blocked and blocking SQL statements in the email (still logged to table).Schedule the procedure to run at defined intervals (I use 2 minutes)
2005-05-12 (first published: 2005-05-02)
1,436 reads
Table Sizes in database
This script uses the same information sp_spaceused does. It just formats it in a different way.
2005-05-10 (first published: 2005-04-26)
202 reads
Restore Multiple Backup Logs
Use This Script to restore Multiple Log backups from a Log Device file. The script will restore all the logs on the device and will leave the databse ready to use after finish. Before running this script you must verify if the database is in No recovery mode or read only state
2005-05-09 (first published: 2005-04-25)
440 reads
Grant EXECUTE permission to users
This procedure will assist in granting execute rights to a database user to all the stored procedures in a database The parameters to this procedure are the databasename and the username to whom EXECUTE rights need to be given to The assumption here is that the user already has access rights to the database mentioned […]
2005-05-05 (first published: 2005-04-19)
231 reads
HexToINT
An optimized function for converting a HEX string into a INT. Built for being faster then other HexToDec converters.Slightly slower then HexToSMALLINT.If there is any faster function to do this conversion, I am intrested of using it instead.
2005-05-04 (first published: 2005-04-19)
298 reads
Script to Move Indexes off of the Primary Filegrou
This is a stored proc that will move your indexes to two new file groups. A Cindex file group is for the clustered indexes and NCindex file group is for non clustered indexes. The parameters for this procedure are @CPATH - the path to the clustered index datafiles @NCPATH - the path to the nonclustered […]
2005-04-29 (first published: 2005-04-15)
395 reads
Get SQL code Blocking and Blocked procs + Notif
This script was created to Identify Query string that is blocked and the one that is blocking with a datetime reference. These information is stored in a history table.It also sends a mail notification without using SQL Mail
2005-04-28 (first published: 2005-04-15)
1,191 reads
Execute SQL-DMO Database method on all databases
This script allows you to specify a method and a server (or multiple servers.) It will then execute the method on every database on the server. With very minor tweaking you could have it search for the servers, then call the server db script with each one, or add another nesting to call tables or […]
2005-04-27 (first published: 2005-04-14)
723 reads
Blogs
Why I stopped using MCP for AI coding stuff
By HeyMo0sh
Something has shifted quietly in 2026. The developers I know/respect—the ones actually shipping, not...
AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
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