Month: April 2012

3 Sessions submitted to SQL Saturday in Salt Lake City

I am planning on visiting Salt Lake City for SQL Saturday in October. Exploring the TSQL Enhancements in SQL Server 2012 Unleashing Common Table Expressions in SQL Server Using SSRS reports to analyze SQL Server health

Posted in SQL Saturday Tagged with:

Using a CTE in a Function to Split Up a Query String

The question came up as to how do I parse a query string using TSQL.  So here you go, using a common table expression, and basing this on a similar function to what I put together yesterday for split. which

Posted in CTE Tagged with: , , , , ,

Using a CTE to Split a String Into Rows

One of the common questions that comes up in my CTE class/presentation asks can you use the CTE inside of a function or stored procedure. The answer is yes, but today I came across another question, how can I split

Posted in CTE Tagged with: , , ,

Finished my Draft Copy of my Chapter for SQL Tribal Knowledge book

I finished my draft copy of my chapter titled “Minimal Downtime and Minimal Risk SQL Server Upgrades” for the SQL Tribal Knowledge book. I am sure there will be some editing and cleanup to do, but for now I am

Posted in TribalSQL


Its about time, MySQL has had a feature LIMIT which is similar to the  usage of OFFSET and FETCH for years.  Now in SQL Server 2012 Microsoft introduces OFFSET and FETCH. The OFFSET and FETCH functionality is used to achieve

Posted in CTE, SQL 2012, TSQL 2012 Tagged with: , , , , , , ,

My Top 10 TSQL Enhancements in SQL Server 2012

So far after playing around with SQL Server 2012 there are many new features to SQL.  Overall I think my favorites are in the Analytic Functions category.  Here is my breakdown of the top 10 transact SQL enhancements to SQL

Posted in SQL 2012, TSQL 2012 Tagged with: , , , , , , ,

Can we use CTEs use in SSRS?

One of the common questions that I get asked after my Unleashing CTE Presentation is “Can we use CTEs in SSRS reports?” The answer is YES, Common Table Expressions work great in SSRS reports, one of my favorite ways of

Posted in CTE, SSRS Tagged with: , ,


For years I have heard the question of how can I do an IIF in TSQL?  Honestly I never thought it would be that useful since the CASE statement is easy enough to use, but after seeing it in TSQL

Posted in TSQL 2012 Tagged with: , , , ,