Tag: Stored Procedures

Temporary Stored Procedures #sproc

Yes, you can create temporary stored procedures by prefixing the name of the sproc with a #. The temporary stored procedure is sort of a “leave no trace” stored procedure that is only good for your session. If you use

Posted in TSQL Tagged with: , , , , , , ,

Database Health Monitor Version 2.4.2 Released Today

Today I released the latest update to Database Health Monitor.  Version 2.4.2. It has been about a two weeks since version 2.4.1 release and version 2.4.2 has a few new features, and a couple bug fixes. Here is a preview of

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

Beta release 1.2 of SchemaDrift – the database schema comparison tool

Today I released another beta release of SchemaDrift. Part of this release was some redesign of the main screen, as shown here. I had some great help from some of the beta testers, and there have been many bugs fixed and

Posted in SchemaDrift Tagged with: , , ,

Introduction to CTEs Slides and Sample Queries

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

Posted in CTE, CTE Book, SQL Saturday 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: , , , , , , ,

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

Posted in CTE, CTE Book, Database Health, SQL 2012 Tagged with: , , , , , , , ,

CTE Data Paging in a Procedure

Day 15 of Common Table Expression Month (June) at SteveStedman.com, today we will be taking a look at data paging with CTE’s in a function. Yesterday we took a look at CTEs for Data Paging, today we will build on what

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

CTE Data Paging

Day 14 of Common Table Expression Month (June) at SteveStedman.com, today we will be taking a look at data paging with CTE’s and how it compares to the offset and fetch in T-SQL 2012. Now on to CTE Data Paging. These queries

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

Nested CTE’s Gone Wild – The Video

Day 12 of Common Table Expression Month (June) at SteveStedman.com, today we will be taking a look at how to use multiple nested CTEs in a query to use up all the memory on your SQL Server. These queries will be

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

Nested CTEs

Day 11 of Common Table Expression Month (June) at SteveStedman.com, today we will be taking a look at how to use multiple nested CTEs in a query. These queries will be using that database that was set up in a previous posting

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