Month: May 2013

End of DBCC Command Month

As the month of May comes to an end so does DBCC command month at SteveStedman.com. I didn’t cover all the DBCC Commands this month, but here is what I did have time to cover: May 1st – DBCC CheckAlloc May

Posted in DBCC Commands Tagged with: , ,

DBCC SqlPerf

Being day 27 of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC SQLPERF. Description: DBCC SQLPERF is used to do a couple different things. Show a list of all the wait stats on your SQL Server.

Posted in DBCC Commands Tagged with: , , , , , , , ,

DBCC ShrinkFile

Being day 25 of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC SHRINKFILE. Description: DBCC SHRINKFILE is used to shrink an individual log in SQL Server. DBCC SHRINKFILE Syntax: Example: The following example DBCC ShrinkFile is

Posted in DBCC Commands Tagged with: , , , , ,

DBCC ShrinkDatabase

Being day 24 of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC SHRINKDATABASE. When I first heard about DBCC Shrink Database (many years ago), I immediately thought “what a great feature, run this every night when

Posted in DBCC Commands Tagged with: , , , , , , , , , , , , ,

DBCC OutputBuffer

Being day 22 of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC OUTPUTBUFFER. I missed a few days on the DBCC Commands due to attending SQL Saturday in Redmond, and the release of my book on

Posted in DBCC Commands Tagged with: , , , , , ,

Common Table Expressions Book at Amazon.co.uk

As a first time published author it is exciting to see that my Common Table Expressions book is now available on the Amazon.co.uk website.  It showed up on Amazon.com about a week ago, and now its available in the UK.

Posted in CTE Book Tagged with: ,

Common Table Expressions Presentations Updated.

I used to be able to do the Common Table Expression in a single 1 hour session, but after writing the book on Common Table Expressions, I discovered that I just can’t fit it into an hour with the detail

Posted in CTE, SQL Saturday Tagged with: , , , , , ,

Common Table Expressions Book Excitement

My common Table Expressions book became available on Amazon.com late last week. After presenting on Common Table Expressions at SQL Saturday yesterday, the sales jumped a bit to the point that the CTE Book is now #2 in the Hot

Posted in CTE Book Tagged with: , , ,

A Great Day At SQL Saturday Redmond

It was a great day at SQL Saturday today. I was able to preview my Common Table Expressions Book at my Common Table Expressions presentation.  The presentation was great, the room was packed, and there were lots of great questions.

Posted in SQL Saturday Tagged with: , , ,

Common Table Expressions Book Available at Amazon.com

My Common Table Expressions book is now available at Amazon.com as both the normal printed book, and the Kindle version. Just in time for SQL Saturday Redmond tomorrow. Paperback Kindle

Posted in CTE
Top