This script will record all the rows in all tables of the database it's run on. Then, at each execution, it will compare the rows to what they originally were and display those that are different (inserts or deletes):
2003-08-20
313 reads
This uses info in backup tables to display growth of datafiles (LDF and MDF) and actual datagrowth (backupsize) over a period of time. Replace parameter values with name of your database and date from when you want info displayed. Results are best viewed in grid.
2003-08-20
413 reads
This function takes a pattern to be searched for, a string that the pattern will be removed from and a flag to determine whether all instances of the pattern should be removed.This is sort of an expanded version of a function I wrote to remove multiple spaces from a string.
2003-08-20
198 reads
SQL 2000's sp_MSForEachDB and sp_MSForEachTable are useful procedures for performing operations against multiple objects; however, they aren't always extremely efficient, because internally they use cursors to do their work.These 2 sprocs, sp_ForEachDB and sp_ForEachTable, perform many of the same tasks as their Microsoft-shipped twins, but run faster because they dynamically build the SQL string without […]
2003-08-19
2,299 reads
This script is similar to Column_Gitter. I noticed this script and wanted to present the same output without the use of cursors. Both scripts work well and produce the same results. This little utility comes in handy if you do a lot of SQL coding. Given a table name, it'll return four results: The names […]
2003-08-14
111 reads
This script returns a description of the database with references to all tables in the database with keys listed. If the column description has been filled out the listing includes that text.If you want to get a report on the structure of each database, just add this script to each database, and then use a […]
2003-08-14
837 reads
2003-08-14
220 reads
This function is similar to the ISNUMERIC native function, but tests for a valid integer. ISNUMERIC can return false positive results when testing for a valid integer. For example this select returns a value of 1 (true):select isnumeric('3d8')For 6.x and 7.0, you can easily convert it to a procedure.
2003-08-14
3,072 reads
These four scripts list concise information about all Default, Check, Unique, Foreign Key, and Primary Key constraints for the database in which they are run. With minor column modifications, they could easily be unioned to provide a single list. The usual caveat applies about directly accessing system tables. They may change in future versions and/or […]
2003-08-14
1,133 reads
Very simple and straightforward script that creates a temporary table and fills it with prime numbers from 1 to the upper bound you specify. May be useful for educational purposes or even some cryptography applications.
2003-08-14
171 reads
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
I’ve been running this blog on Hugo for a long time, and like most...
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
Comments posted to this topic are about the item Admin Rights for Everyone
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
Comments posted to this topic are about the item RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers