Главная
Study mode:
on
1
Intro
2
Technical Assistance
3
SUMMIT 2015
4
Advanced Common Table Expressions
5
Recursion Overview
6
Recursive Terminology
7
Demo: Recursive CTE
8
Recursive Demo
9
Recursive CTE Notes
10
Hierarchy with multiple recursive queries is possible
11
Hierarchy with advanced formatting
12
Recursive Heirarchy Demo
13
Manipulating Data
14
Deleting From a CTE
15
Inserting to a CTE
16
Updating a CTE
17
INSERT, UPDATE, DELETE Notes
18
CTE Common Use Case 2
19
CTE Performance Considerations
20
Nested CTES
21
Recursive Performance
22
Deep Recursion
23
Classic Recursive Algorithms
Description:
Dive into advanced Common Table Expressions (CTEs) in this 53-minute conference talk from PASS Data Community Summit. Explore recursive queries and hierarchical data display using CTEs. Learn how to perform INSERT, UPDATE, and DELETE operations on CTEs. Discover common use cases including finding pattern holes, removing duplicates, and string parsing. Compare CTEs to SQL Server 2012 offset and fetch paging techniques. Gain in-depth understanding of CTE performance, identifying when to use them effectively. Examine classic recursive algorithms implemented with CTEs. Walk away with practical CTE samples to enhance your T-SQL query skills.

Common Table Expressions - Advanced

PASS Data Community Summit
Add to list
#Conference Talks #PASS Data Community Summit #Programming #Domain-Specific Languages (DSL) #SQL #Transact-SQL (T-SQL) #Computer Science #Algorithms #Data Science #Data Manipulation #Common Table Expressions
0:00 / 0:00
1 of 23

Intro