Comparing Stored Procedures, Part 3
Third in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures
2011-03-30 (first published: 2009-02-16)
2,493 reads
Scripts
Comparing Stored Procedures, Part 2
Second in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures
2011-03-29 (first published: 2009-02-09)
2,578 reads
2011-03-28 (first published: 2009-02-06)
8,177 reads
SQL 2005 Rebuild\Reorganize Indexes with Reports
This custom sp rebuilds \ reorganizes indexes for SQL 2005 databases and logs results for further analysis.
2011-03-25 (first published: 2009-02-16)
7,227 reads
My favorite way to access Excel files
Using opendatasource to retrieve data from Excel files as if querying a table.
2011-03-22 (first published: 2009-01-27)
11,929 reads
2011-03-18 (first published: 2010-09-21)
2,891 reads
Update 2 databases with 1 script
This script will allow you to update 2 databases with the same names, but different schemas/software/database versions.
2011-03-14 (first published: 2011-03-03)
2,256 reads
Get Item from Delimited List at Position
Returns the item from a delimited list at the specified position. Both position and delimiter are parameters.
2011-03-10 (first published: 2011-02-21)
1,115 reads
2011-03-09 (first published: 2011-02-21)
853 reads
2011-03-07 (first published: 2011-02-21)
8,723 reads
Blogs
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
Your AI is busy. But do you know what it's worth? Most companies can...
Forums
Alamat BCA KCU BINTARO Telp:0821°8200°233
Telp/Wa 628218200233 Bintaro Jaya Blok A-5 No.12 & 15, Sektor 7, Pd. Jaya, Kec....
Alamat BCA KCP Labuan Telp:0821°8200°203
Telp/Wa 628218200203 Jl. Raya Labuan - Pandeglang No.01, Labuan, Kec. Labuan, Kabupaten Pandeglang, Banten...
Alamat BCA KCP Cilegon II Telp:0821°7555°651
Telp/Wa 628217555651 Ruko Cilegon City Square, Jl. Pondok Cilegon Indah No.1 Blok A No....
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers