Recursive CTE’s
As part of my planning for the SQL Saturday Presentation in Vancouver I am creating an hour long presentation on Common Table Expressions. The easiest… Read More »Recursive CTE’s
SteveStedman
Another Session Submitted for SQL Saturday
I just submitted a second abstract for SQL Saturday titled Unleashing Common Table Expressions in SQL Server. This is for the SQL Saturday Redmond and… Read More »Another Session Submitted for SQL Saturday
Free – Duplicate Indexes Report – Updated
After creating and deploying the duplicate indexes report earlier today I discovered that although the report did exactly what it says, it didn’t do what… Read More »Free – Duplicate Indexes Report – Updated
Free – New Duplicate Indexes Report added
After yesterdays Long Running Queries Report, I have decided to add one more SQL Server Health report. A duplicate indexes report has been added to the Server Health… Read More »Free – New Duplicate Indexes Report added
Free – Long Running Queries Report Created
A long running queries report has been added to the Server Health reports. With this report you can track down time consuming queries that may… Read More »Free – Long Running Queries Report Created
Abstracts submitted to SQL Saturday
I just submitted abstracts to SQL Saturday #114 in Vancouver and #108 in Redmond. The Redmond SQL Saturday appears to be the more popular of… Read More »Abstracts submitted to SQL Saturday
Error code 0x85640004 when installing SQL Server 2012 RC0 on a Non Domain Computer
Today I ran the install of SQL Server 2012 RC2 on another computer this time a Windows 7 computer not on a domain. Here is… Read More »Error code 0x85640004 when installing SQL Server 2012 RC0 on a Non Domain Computer
Virtual SQL Server Class Survey #1
I am creating a SQL Server web based class to be held on a weekly basis. If you were to attend, what time would work… Read More »Virtual SQL Server Class Survey #1
A Fun Thanksgiving Day Query.
Download the Thanksgiving query sample code here. I thought it would be fun to put together a query to get us in the spirit of Thanksgiving… Read More »A Fun Thanksgiving Day Query.
SQL Server 2012 Compatibility Level
SQL 2012 Compatibility Level With SQL Server 2012, there was a new compatibility level being introduced, level 110 the new SQL 2012 compatibility level. SQL Server can… Read More »SQL Server 2012 Compatibility Level