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)
450 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)
383 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)
384 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,976 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,598 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)
372 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)
256 reads
I use these to manage the addition and removal of extended properties on all tables and columns in my company's dbs.Rather than writing complicated joins or calling functions every time, I use views on sysobjects and INFORMATION_SCHEMA tables. I tried to make these scripts as flexible as possible so you can reuse them in procedures, […]
2006-01-05 (first published: 2005-11-11)
1,271 reads
With this script you can see the permissions that every user-defined role and every user without a dbrole has.The list could get very large and hard to manage, but it helped me to build the roles of an app that didn't had any role defined.Hope it'll be usefull to someone
2006-01-02 (first published: 2005-12-08)
727 reads
2005-12-30 (first published: 2005-12-09)
164 reads
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Comments posted to this topic are about the item Four Rules for Adding AI...
Hello, the title says it all. Is the SQL Server 2025 section missing?
I am not sure which is the best way to proceed. I have parent...
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers