Month: June 2013

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: , , , , , , , ,

Trust Me – I’m a Database Administrator

I love this T-Shirt that I found at Amazon.com. Trust Me ! I’m A Database Administrator Mens T-shirt

Posted in Uncategorized

What Do You Use CTEs for?

There are many great reasons to use Common Expressions, from derived table query re-use, to doing recursive queries and creating hierarchies to doing data paging, cleaner code, or de-duplication of data. I am curious what you are using CTE’s for?

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

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

Posted in Uncategorized 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: , , , , , , , ,

Query To Simulate CPU Load

Quite often when working testing different performance measures from the Database Health Reports to testing Resource Governor configuration I end up in a situation where I need to emulate a high CPU load on my test SQL Server. In this

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

Database Health Reports – Seven Hundred Downloads So Far

Since the initial release of the Database Health Reports project last September, there have been over 700 downloads of the application at this point Beta6 is going strong. First I would like to say Thank You to everyone using it so far. Beta

Posted in Database Health Tagged with: , , ,
Top