This VB script allows you to search DTS packages for keywords, etc. It is also useful for quickly locating what server a given package is on. This is very useful for debugging. Example - you want to know the name of every DTS package the touches a certain table. The text files generated contain the […]
2006-01-18 (first published: 2005-12-07)
6,028 reads
This funciont return a date without end-of-week , it is useful to calculate a new date for any payment!YOU CALL with 'dias_uteis(getdate(), 5)' and will get five useful days after today
2006-01-17 (first published: 2005-12-22)
100 reads
SP_WHO_3 is a very powerful utility for all DBAs. It displays processes connected to the system and what they are doing. It can find blocking processes, can return the Input Buffer for everything in the recordset returned, and provides immense filtering and sorting capabilities. It's designed to be extremely efficient, yet it provides many more […]
2006-01-17 (first published: 2004-08-12)
2,457 reads
I found my self in a fimilar situation where I wanted to modify a table but was not sure how heavily it was used. So I started out with a script that just searched for a table. Then I tought to my self...self...What about all those times you want to expand a column or drop […]
2006-01-16 (first published: 2005-12-22)
442 reads
This Script finds the maximum length of a value in Character type Column.(CHAR,VARCHAR,NVARCHAR) and finds the difference between the Total lenghth and maximum value inserted
2006-01-13 (first published: 2005-12-27)
368 reads
Returns information about all the data / log files on a server, such as total file size, % used & free, etc.Can be set to filter out db's you don't want to monitor.When edited to allow the "update usage", numbers reported will be more accurate.Note: if you edit to allow update usage and intend to […]
2006-01-12 (first published: 2005-12-27)
373 reads
This script will create a series of insert statements for a given table. It does not support every single data type in every way and has some limitations. If you add any enhancements, please send them to me at bbyrd@intellithought.com so I can update it here. Update (28 Feb 2005): Added support/Fixed bug with smalldatetime […]
2006-01-11 (first published: 2005-02-14)
4,963 reads
GETWORDCOUNT, GETWORDNUM, AT, RAT, OCCURS,CHRTRAN, STRFILTER, PADC, PADR, PADL, PROPER, RCHARINDEX etc. AT, PADL, PADR, CHRTRAN, PROPER are similar to functions Oracle PL/SQL INSTR, LPAD, RPAD, TRANSLATE, INITCAP. In my humble opinion, it will be convinient to apply such functions for writing of stored procedures and User-Defined Functions on Transact-SQL. Please, download the file http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,27115
2006-01-10 (first published: 2005-04-19)
1,587 reads
This simple script identifies all objects which have a rollback transaction statement without a requisite begin transaction statement. If a rollback statement is issued without a begin statement, then the code will generate an error. Triggers are not included in the list since they can have a rollback without a begin. This script can be […]
2006-01-09 (first published: 2005-09-16)
364 reads
this script lists the report Execution History ex: timetaken to render, retreive data, number of records retreived and their size etc.. in descending order of its execution timeReports the ReportName, its Path , TimeTaken to execute the report, retreive the data, render the report, total count of rows returned and the total data returned in […]
2006-01-06 (first published: 2005-10-20)
250 reads
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Hub Via Wa:628218154374 Alamat Jl. HOS Cokro Aminoto No.56-58, Muka, Kec. Cianjur, Kabupaten Cianjur,...
Hub Via Wa:628218154374 Alamat Jl. Margonda Raya No.182, Kemiri Muka, Kecamatan Beji, Kota Depok,...
Hub Via Wa:628218154374 Alamat Jl. Alternatif Cibubur RT.005/09. Kel. Harjamukti, Cibubur, Kec. Cimanggis, Kota...
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers