List columns data type and size for every table in a database
This script will list columns data type and size for every table in a database.
2009-09-15 (first published: 2009-09-02)
2,019 reads
Scripts
Dynamic Select Generator
Query to generate a dynamic Select statement from any table for moving data between servers.
2009-09-11 (first published: 2009-09-01)
1,622 reads
Encrypt All Stored procedures at once
this code encrypts all stored procedures that meet a certain format. this code is easy to change to suit your particular needs, but be sure to back up your stored procs first.
2009-09-10 (first published: 2008-11-21)
3,333 reads
2009-09-09 (first published: 2009-08-31)
1,316 reads
2009-09-08 (first published: 2009-08-31)
489 reads
Nth occurrence of a weekday in a month and year
To find date at nth occurrence of a weekday in a month and year
2009-09-07 (first published: 2009-09-01)
756 reads
2009-09-04 (first published: 2009-08-31)
2,298 reads
Move one Filegroup to another
This script copies all tables found in a specific filegroup to another specific filegroup.
2009-08-19
118 reads
Find all Procedures, Views, Functions that have been renamed
Find all Procedures, Views, Functions that have been renamed with sp_rename where syscomments does not match.
2009-08-17 (first published: 2009-08-06)
965 reads
BCP Format File Builder
Utility stored procedure to create non-xml format file for BCP/BULK INSERT processes. Very useful for text-qualified CSV files.
2009-08-14 (first published: 2009-08-04)
2,421 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Hyperscale Replicas II
Comments posted to this topic are about the item Hyperscale Replicas II
Practical Reporting Queries with CROSS APPLY (Part 3)
Comments posted to this topic are about the item Practical Reporting Queries with CROSS...
Your Favorite Quotes
Comments posted to this topic are about the item Your Favorite Quotes
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers