Blog Archives

CTE to Split a String in a function SplitString

Back in 2012 when I was writing my Common Table Expressions book, I came up with the following CTE in a function to split a string into rows. Original Post: http://stevestedman.com/2012/04/using-a-cte-to-split-a-string-into-rows/ At the time, I thought it was pretty handy

Posted in CTE Book Tagged with: , , , , , , ,

SSRS Report Usage Queries

This last week I had the opportunity to do some work with SSRS, determining some stats on report usage. I ended up digging up some queries that I wrote a couple years ago against the ReportServer database, and thought they

Posted in SSRS Tagged with: , , , , , , ,

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

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)

Posted in PASS Summit Tagged with: , , , , , ,

Max Server Memory – SQL Server

Max Server Memory Setting Explained If you have more memory than your database and applications on the SQL Server will ever use than this is not a problem, but when you run into memory constraints this setting is much more

Posted in Performance, Server Health Tagged with: , , , , , , ,

Database Health Monitor Version 2 Almost Done

Over the last 4 years I have been working on the Database Health Monitor. I am about a week away from releasing Version 2, which will finally be out of the beta process. In preparation for the release I am

Posted in Database Health Tagged with: , , , , , , ,

Using a Common Table Expression Instead of a Derived Table

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

Posted in Classes, CTE Tagged with: , , , , , , ,

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

Posted in CTE Tagged with: , , , , , , ,

Database Health Reports Beta 9 – Released

Today I have released beta 9 of the Database Health Monitor. It has been 27 months since the release of Database Health Beta 1, and almost 4 years since the original SSRS implementation of Database Health reports. To be honest

Posted in Database Health Tagged with: , , , , , , ,

Introducing the Joes2Pros Academy

The new Joes2Pros Academy has just launched. The Academy provides an interactive classroom experience that can be accessed on your own time as you need it. This site has high quality content, quizzes and exams. Students can interact with other students and instructors

Posted in Academy, DBA, SQL 2012, TSQL 2012 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

Posted in CTE, CTE Book Tagged with: , , , , , , ,

SQL Server Performance Tuning

Need help with SQL Server Performance Tuning, contact Steve at Stedman Solutions, LLC for help, or take a look at the performance tuning page at the SteveStedman.com blog. We can help with tuning a single query or with figuring out why your SQL Server is running slow. Free 30 minute consultation.

Newsletter Signup

Stay informed of Database Corruption Challenge events, and other things happening at SteveStedman.com with my newsletter.
Newsletter signup form.

Stedman Solutions

StedmanSolutionsRemoteSkilledDBA

Archives