2019-10-28
5,711 reads
Advanced SQL
Create a Tally Function (fnTally)
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)
2,738 reads
Stairway to Advanced T-SQL Level 3: Understanding Common Table Expressions (CTEs)
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.
2015-03-18
1,906 reads
Create a Tally or Numbers Table
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,507 reads
Blogs
SSIS Logging – Linking sysssislog with custom log
I was working on an ETL solution, which was expected to run for hours....
Azure Arc
By Vinay Thakur
Azure arc is another great stuff coming with Microsoft Azure, as we were expecting...
Built-in Duotone Image Filter, Editor Navigation via Persistent List View, and Other Block Editor Improvements
By todd-32417
The next batch of exciting updates to the block editor is live on WordPress.com....
Forums
Log shipping performing log backups despite its backup jobs being disabled
Hi Came across an odd issue this evening. Running a migration over the weekend...
Granting Schema Permissions
Comments posted to this topic are about the item Granting Schema Permissions
Lots of Data and AI Helping Firefighters
Comments posted to this topic are about the item Lots of Data and AI...
Ask SSC