TSQL to Determine Plan Cache Size
In SQL Server 2012, there was a change to the dynamic management view that reports on the plan cache, so the query has changed. Here… Read More »TSQL to Determine Plan Cache Size
TSQL
Home after Seattle (Redmond) Code Camp 2012
What a great day at Code Camp today. Click here to download the slides and sample code from the presentations. The first presentation that I… Read More »Home after Seattle (Redmond) Code Camp 2012
Code Camp in Redmond Today
I am headed to Code Camp in Redmond WA today. I ended up with 3 sessions that I will be presenting, and I am really looking forward… Read More »Code Camp in Redmond Today
TSQL 2012 CHOOSE Function
In SQL Server 2012 there is a new function called CHOOSE that takes in an offset, and a list of options. Choose is a function… Read More »TSQL 2012 CHOOSE Function
Sessions Submitted for SQL Saturday – Olympia
SQL Saturday 166 in Olympia WA on November 10th was announced, and that one is close enough to drive to. I have submitted 2 sessions… Read More »Sessions Submitted for SQL Saturday – Olympia
Sessions for Code Camp in 2 weeks
Here are the sessions that I will be presenting at Code Camp in two weeks.. What’s New in TSQL 2012 This is the first time… Read More »Sessions for Code Camp in 2 weeks
Sessions Accepted for Seattle Code Camp 2012
I learned today that several of the sessions that I pitched for Code Camp 2012 have been accepted. Code Camp will be on Saturday June… Read More »Sessions Accepted for Seattle Code Camp 2012
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… Read More »Using a CTE in a Function to Split Up a Query String
TSQL 2012 – OFFSET and FETCH
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… Read More »TSQL 2012 – OFFSET and FETCH
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… Read More »My Top 10 TSQL Enhancements in SQL Server 2012