Performance Testing Script
Fourth in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures
2013-10-31 (first published: 2009-02-17)
10,581 reads
Insert Commas Into Number String
Function to take a number as a string and return it with commas separating thousands, millions, etc.
2013-06-07 (first published: 2009-03-31)
2,426 reads
Identify Unique Columns
Tool to automatically query combinations of columns in your table to determine candidate for unique key.
2012-08-21 (first published: 2008-01-28)
2,893 reads
2012-03-26 (first published: 2008-01-23)
3,243 reads
Generate INSERT for table with IDENTITY column
Generate a "INSERT INTO...SELECT FROM" script for a table with an identity column.
2012-03-09 (first published: 2008-01-07)
4,245 reads
2011-09-20 (first published: 2008-01-11)
2,495 reads
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,438 reads
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,524 reads
2011-03-28 (first published: 2009-02-06)
8,113 reads
Comparing Stored Procedures, Part 6
Sixth in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures
2009-04-15 (first published: 2009-02-26)
1,415 reads
Blogs
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Forums
BCA KCP Mal Pondok Indah Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Ground Floor G31 & G32, Jl. Metro Pondok Indah, Daerah Khusus Ibukota Jakarta...
BCA KCU SOLO BARU TLP/WA 08216977749
Kawasan Terpadu The Park, Jl. Ir. Soekarno, Solo Baru, Madegondo, Kec. Grogol, Kabupaten Sukoharjo,...
BCA KCP Pasar Legi TLP/WA 08216977749
Jl. Letjen S. Parman No.135, Kestalan, Kec. Banjarsari, Kota Surakarta, Jawa Tengah 57133
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers