Tag: Common Table Expression

What is a Common Table Expression

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

Tagged with: , , , , , , ,

SQL Saturday #265 in Portland Oregon

I will be attending SQL Saturday #265 in Portland Oregon on November 16th 2013. This will be my second time attending SQL Saturday in Portland, and it is looking to be a great event. There are some great speakers on

Tagged with: , , , , , , ,

What is a Common Table Expression – Video

  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

Tagged with: , , , , , , ,

SQL Server Crossword Puzzle

Across 2. Management Studio 5. The database that is used as a template when creating a new database 6. Using a backup 7. Reporting Services 9. An index that rearranges the structure of a table 12. The underlying structure of

Tagged with: , , , , ,

End of June Summary

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

Tagged with: , , , , , , , ,

Week In Review – June 15th 2012

It has been a busy week at SteveStedman.com. Here is a quick summary of this weeks postings: June 14th – CTE Data Paging June 13th – Query To Simulate CPU Load June 12th – Nested CTE’s Gone Wild – The Video June

Tagged with: , ,

Introduction to Recursive CTEs

Day 7 of Common Table Expression Month (June) at SteveStedman.com, today we will be taking a look at the introduction to recursive CTEs. These queries will be using that database that was set up in a previous posting on the CTE_DEMO

Tagged with: , , , , , , , , , , , ,

250th Blog Post at SteveStedman.com

This is my 250th blog post at Steve Stedman.com.  Many of the post over the last year have been focused on Common Table Expression topics as I finished my CTE Book, however with last month being DBCC Command Month here

Tagged with: , , ,

Common Table Expression (CTE) Month at SteveStedman.com

This month is going to be Common Table Expressions Month at SteveStedman.com.   My goal is to post one valuable post on a Common Table Expressions topic each day for the entire month. What is a Common Table Expression A

Tagged with: , , , , , , , ,

Common Table Expressions Presentations Updated.

I used to be able to do the Common Table Expression in a single 1 hour session, but after writing the book on Common Table Expressions, I discovered that I just can’t fit it into an hour with the detail

Tagged with: , , , , , ,