Many people have published high performance, read-less, Inline Table Valued functions that use Itzik Ben-Gan's wonderful "Virtual Numbers Table" to replace WHILE loops and other forms of RBAR. This one is Jeff Moden's version.
2019-08-13 (first published: 2019-08-04)
933 reads
A CTE is a temporary result set defined by a simple query, and is used within the execution scope of a single INSERT, UPDATE, DELETE, or SELECT statement. In this article we will explore how to define and use CTE's.
2018-03-21 (first published: 2015-03-18)
586 reads
This creates a Tally or Numbers table which is frequently used to replace loops in code and is much faster than most loops.
2011-11-24 (first published: 2008-03-07)
6,492 reads
By Steve Jones
This year at the PASS Summit, Redgate is holding our SQL in the City...
By Arun Sirpal
In the previous blog post I did a quick overview building a SQL VM...
By Ed Elliott
It has been a little while but I have updated SQLCover to include a...
Hello I have a SQL task that ran through yesterday in around 23...
Hi All, Need some help in exception handling. In below code, I want to...
Hi, I am taking full backup of db on remote location. The issue we...
Ask SSC