Yet Another Pad Utility
A useful user defined function for padding values from the left or right with any token, number, or character.
2008-11-07 (first published: 2008-09-13)
789 reads
Scripts
2008-11-06 (first published: 2008-09-12)
1,056 reads
Get Record count of all tables of current database
This script will return record count of all user tables from the current database
2008-11-05
1,091 reads
Add Primary key
This Store procedure is used to add primary key to all tables in a database, if table does not contain it.
2008-11-04
989 reads
2008-11-04
1,964 reads
Delimited String Parsing Functions - TwoCol set
Feed it two delimited strings of horizontal data and it returns it back as a vertical table with the two column data in the same synchronized position order.
2008-11-03 (first published: 2008-08-05)
2,237 reads
SP to find the database usage
This SP helps you to find the data file/s and log usage for a given DB
2008-11-01
1,326 reads
Compare SQL code of 2 objects.
Compare SQL code of sp, functions, or triggers. Can run across DB and/or servers. Generates report similar to windif. See details in comments
2008-10-31 (first published: 2008-09-05)
1,134 reads
Find a string in compiled objects
This utility will find strings in procedures, functions, views, and even check constraints.
2008-10-31
456 reads
Insertion and Deletion by using Partition
for huge data insertion and deletion by avoiding locking you can use partition tables.
2008-10-28
815 reads
Blogs
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers