Query String Archives - Steve Stedman

Epic Life Goal Completed: Speaking at PASS Summit – Advanced CTEs

By SteveStedman Posted on November 3, 2015 Posted in PASS Summit No Comments Tagged with Common Table Expressions, CTE, Fibonacci Sequence, Query String, SQL Server, SSRS, Tree Path

Last week I had the great opportunity to speak at PASS Summit 2015. My presentation was on Common Table Expressions. Here is the sample code from the presentation. AdvancedCTEs.zip Related Links: Common Table Expression (CTE) Month at SteveStedman.com (introduction) Sample Database for Common Table Expressions Writing Your First Common Table Expression with SQL Server Video: Writing Your First CTE …

Epic Life Goal Completed: Speaking at PASS Summit – Advanced CTEs Read more »

24 Hours of PASS – Advanced CTE Presenation

By SteveStedman Posted on June 24, 2015 Posted in CTE No Comments Tagged with Common Use Cases, CTE, Manipulating Data, PASS, Query String, Recursive Queries, Related Links, SQL Server

Today I am presenting on Advanced Common Table Expressions as part of the 24 Hours of PASS conference. It is being webcast so check it out if you can. The outline for the presentation will be the following: Recursive Queries Hierarchical Recursive Data Manipulating Data Common Use Cases CTE Performance Considerations Classic Recursive Algorithms The sample code and slides are …

24 Hours of PASS – Advanced CTE Presenation Read more »

Using a Common Table Expression Instead of a Derived Table

By SteveStedman Posted on February 20, 2015 Posted in Classes, CTE No Comments Tagged with Common Table Expressions, CTE, Fibonacci Sequence, Query String, SQL Server, SSRS, Tree Path, TSQL

Here is a short video that shows how to convert those ugly derived table (SubQuery) queries into a common table expression to help clean up your TSQL code. This applies to Common Table Expressions on Microsoft SQL Server, and the recording comes from my Free SQL Query Training course. Other CTE Related Posts: Writing Your First Common Table Expression …

Using a Common Table Expression Instead of a Derived Table Read more »

What is a Common Table Expression

By SteveStedman Posted on February 20, 2015 Posted in CTE No Comments Tagged with Common Table Expression, CTE, Fibonacci Sequence, Query String, SQL Server, SSRS, Tree Path, TSQL

I just a added a video to YouTube titled “What is a Common Table Expression”. This video covers the extreme basics of what a CTE is on Microsoft SQL Server, and how to write that CTE in TSQL. Here is the video: It’s a very short video with the basics of what a CTE is. Take a look. Other …

What is a Common Table Expression Read more »

Introduction to CTEs Slides and Sample Queries

By SteveStedman Posted on November 16, 2013 Posted in CTE, CTE Book, SQL Saturday No Comments Tagged with Common Table Expressions, CTE, Data Paging, Fibonacci Sequence, Memory Tables, Query String, SQL Server, Stored Procedures

Today I am at SQL Saturday Portland Oregon, and at 9:00am I am presenting the Introduction To Common Table Expressions session: Here is the abstract: Have you ever wanted to create a recursive query, but didn’t see how to do it. With the Common Table Expressions session you will learn everything needed to start using CTE’s for recursive queries, as …

Introduction to CTEs Slides and Sample Queries Read more »

What is a Common Table Expression – Video

By SteveStedman Posted on August 6, 2013 Posted in CTE, CTE Book 1 Comment Tagged with Common Table Expression, Common Table Expressions, CTE, Query String, SQL Server, SSRS, Stored Procedures, Tree Path

Related Common Table Expression Links Sample Database for Common Table Expressions Writing Your First Common Table Expression with SQL Server Video: Writing Your First CTE with SQL Server Common Table Expressions – Terminating the Previous Statement CTE Scope Introduction to Recursive CTEs Recursive CTE for Dates In A Year Expanding on Recursive Dates CTE Multiple CTEs in a Query …

What is a Common Table Expression – Video Read more »

End of June Summary

By SteveStedman Posted on June 30, 2013 Posted in CTE, CTE Book, Database Health, SQL 2012 No Comments Tagged with Common Table Expression, Common Table Expressions, CTE, Database Health Reports, Query String, SQL Server, Stored Procedures, Tree Path, Windows Server

June was an exciting month for me with Beta 6 of the Database Health Reports releasing at the beginning of the month, and this being CTE Month at SteveStedman.com to mark the release of my Common Table Expressions book. CTE Month Summary CTE Month postings started with the basics on June 1st, and grew throughout the month to include more …

End of June Summary Read more »

SQL Server Memory Hog Query

By SteveStedman Posted on April 2, 2013 Posted in CTE No Comments Tagged with Common Table Expressions, CTE, Fibonacci Sequence, Query String, SQL Server, SSRS, TB, Tree Path

The article could be named, “How to use up all of your SQL Server available memory with a single CTE query.” Another name for the article could just be “SQL Server Bug Report” depending on how you look at it. When presenting unleashing Common Table Expressions at SQL Saturday a while back, I was asked a couple of great questions …

SQL Server Memory Hog Query Read more »

Unleashing Common Table Expressions

By SteveStedman Posted on October 28, 2012 Posted in CTE, SQL Saturday No Comments Tagged with CTE, Olympia Washington, Portland Oregon, Query String, Steve Stedman

On the next two Saturdays I will be presenting the Unleashing Common Table Expressions presentation at SQL Saturday 172 in Portland Oregon, and SQL Saturday 166 in Olympia Washington. As part of refreshing the presentation I have added a few more examples of how CTE’s can be used in common practice. Using a CTE to parse a Query String. Using …

Unleashing Common Table Expressions Read more »

Tag: Query String