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)
598 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)
402 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,489 reads
By Steve Jones
VSCode was making me crazy as I was writing a script. I like a...
By Jen McCown
There’s a very good reason to do most of your DBA work using T-SQL,...
By Gethyn Ellis
To be honest you probably think that migrating to the cloud sounds great, and...
Comments posted to this topic are about the item SQL Tamagotchi! Mini-Servers as Database...
Anyone have any insights on how this licensing works and what the "Use Rights"...
I am working in SSIS (Sql server version 2012) , I have a requirement...
Ask SSC