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,584 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,430 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,901 reads
2012-03-26 (first published: 2008-01-23)
3,246 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,246 reads
2011-09-20 (first published: 2008-01-11)
2,497 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,439 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,527 reads
2011-03-28 (first published: 2009-02-06)
8,116 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,417 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers