2016-03-14
90 reads
2016-03-14
90 reads
The age old question of where should business logic be stored
2015-10-16
292 reads
I had an update statement that took 3 minutes to run after this code change it took 6 seconds.
2015-03-27 (first published: 2014-05-08)
33,510 reads
2015-01-26
12,040 reads
I inherited a database that was getting large and not performing well. After adding primary keys life got better.
2014-06-30
14,643 reads
Some people set their default database to the database they use most often. This can cause issues when a restore fails.
2013-11-14
7,491 reads
Ben Kubicek wrote a recursive function that solves simple math expressions in a select statement. Read about this creative use of T-SQL.
2011-11-21
5,898 reads
Recently Ben Kubicek created a script that would allow him to copy his production db to a test instance and correct the production specific SQL code in stored procedures and views.
2010-02-03
7,431 reads
By Ed Elliott
I recently encountered an interesting issue with ADF where the publish feature suddenly attempted...
Image from Afdhaluddin on ShutterstockCLI which is generally referred to as Command Line Interface...
By Steve Jones
I can’t believe I’ve been at Redgate long enough to get a third sabbatical....
Hi, I’ve provisioned an Azure Database Watcher to monitor our 4 Azure SQL Managed...
Comments posted to this topic are about the item Can You Ask for a...
Comments posted to this topic are about the item Stored Procedure Generation Script
What is returned by this code in SQL Server 2022?
SELECT value FROM GENERATE_SERIES(4, 1);See possible answers