Common Table Expressions Joes 2 Pros®: A CTE Tutorial on Performance, Stored Procedures, Recursion, Nesting and the use of Multiple CTEs
by Steve Stedman
No club is reading this yet — be the first to start one
powerful and often overlooked features in Microsoft
SQL Server. This Joes 2 Pros book will show some of
the more interesting things you can do with a CTE. We
will learn how CTEs are a great alternative to derived
table queries, how to do data paging with a CTE, and
recursive queries with tree path and hierarchical output.
This book will also cover how to use the DELETE,
UPDATE, and INSERT statements with a CTE, and how
to use CTEs in stored procedures and functions. We will
discover what is good and bad with CTEs when it comes
to performance, and how to avoid performance pitfalls.
The twelve chapters take us from the most basic
introduction of a CTE all the way to the more complex
usage scenarios where a CTE can change the way you
look at writing T-SQL queries. Learn how to use a single
CTE or multiple CTEs in a single statement as well as
nesting them.
Discuss Common Table Expressions Joes 2 Pros®: A CTE Tutorial on Performance, Stored Procedures, Recursion, Nesting and the use of Multiple CTEs with other readers
Join or start a book club for Common Table Expressions Joes 2 Pros®: A CTE Tutorial on Performance, Stored Procedures, Recursion, Nesting and the use of Multiple CTEs on Readfeed. Live chat, shared reading progress, and AI discussion questions — free to get started.
Frequently asked questions
How do I join a book club for Common Table Expressions Joes 2 Pros®: A CTE Tutorial on Performance, Stored Procedures, Recursion, Nesting and the use of Multiple CTEs?
Sign up free on Readfeed, then browse public clubs or start your own club with Common Table Expressions Joes 2 Pros®: A CTE Tutorial on Performance, Stored Procedures, Recursion, Nesting and the use of Multiple CTEs as the current read. Invite friends with a share link and discuss together with live chat and AI discussion questions.
Can I discuss Common Table Expressions Joes 2 Pros®: A CTE Tutorial on Performance, Stored Procedures, Recursion, Nesting and the use of Multiple CTEs with other readers online?
Yes. Readfeed book clubs let you chat live, share progress, and join discussions about Common Table Expressions Joes 2 Pros®: A CTE Tutorial on Performance, Stored Procedures, Recursion, Nesting and the use of Multiple CTEs with readers worldwide — whether your club is virtual, in-person, or hybrid.
Is Readfeed free?
Yes. Creating an account and joining book clubs is free. Sign up to find readers who love the same books and start discussing today.