What Exactly Is a CTE in T-SQL? A Comprehensive Guide with 7 Examples
Learn how to use CTEs through the use of a number of examples.
2023-10-20
10,161 reads
Learn how to use CTEs through the use of a number of examples.
2023-10-20
10,161 reads
In this article we cover what a Common Table Expression CTE is and how to write a CTE for doing selects, inserts, deletes, updates and more.
2021-06-02
Introduction This article shows how common table expressions (CTE) in SQL Server are naturally suited for navigating trees, such as finding its longest path, or diameter. Recall that a tree is an undirected graph where unique paths exist between any two nodes (i.e. vertices). Any node may be selected as its top node, with its […]
2021-04-19
8,018 reads
A detailed description of a technique for the the solution of the Bin Packing Problem, that involves a recursive CTE and Window functions
2020-05-14 (first published: 2020-04-23)
5,667 reads
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
You can find all the session materials for the presentation “Indexing for Dummies” that...
By Kevin3NF
Parts 1, 2 and 3 got you to the (SQL) engine room. Now we...
Hey All, I'm looking for a free ERD tool. Does anyone have any recommendations?...
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Comments posted to this topic are about the item Vector Datatype Dimensions
The new vector datatype in SQL Server 2025 requires a number dimension parameter. What is the maximum number of dimensions supported?
See possible answers