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,526 reads
Scripts
2011-03-28 (first published: 2009-02-06)
8,116 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,191 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,868 reads
2011-03-18 (first published: 2010-09-21)
2,852 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,228 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,071 reads
2011-03-09 (first published: 2011-02-21)
805 reads
2011-03-07 (first published: 2011-02-21)
8,668 reads
2011-03-04 (first published: 2011-02-21)
6,127 reads
Blogs
T-SQL Tuesday #199 Invitation: Back to on-prem?
It’s time for T-SQL Tuesday again! And we’re almost to number 200! T-SQL Tuesday...
Data Skew in Data Engineering: What It Is and How to Fix It
You kick off a distributed job expecting it to finish in minutes — but...
Error Deploying GraphQL in Fabric: dm_exec_describe_first_result_set
A while ago we suddenly had an error while trying to deploy one Fabric...
Forums
BCA KCU VETERAN | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Veteran No.18-24, Krembangan Sel., Kec. Krembangan, Surabaya, Jawa Timur 60175 @BCA KCU...
BCA KCU SALATIGA | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Jend. Sudirman Jl. Diponegoro No.15, Salatiga, Kec. Sidorejo, Kota Salatiga, Jawa Tengah...
BCA KCP Iskandar Muda | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Sultan Iskandar Muda No.Kav. 80/1-2, RT.2/RW.3, Kby. Lama Utara, Kec. Kebayoran Lama,...
Question of the Day
Representing Money
Which types of currency does the money data type represent?
See possible answers