I have just released version 2.4.3 the July 2016 version of Database Health Monitor. You can download it now at the Database Health Monitor website. http://DatabaseHealth.com/download Since the releases have been coming about monthly lately, I have decided to add …

Database Health Monitor – July 2016 Release Read more »

Today I released the latest update to Database Health Monitor.  Version 2.4.2. It has been about a two weeks since version 2.4.1 release and version 2.4.2 has a few new features, and a couple bug fixes. Here is a preview of …

Database Health Monitor Version 2.4.2 Released Today Read more »

Back in 2012 when I was writing my Common Table Expressions book, I came up with the following CTE in a function to split a string into rows. Original Post: http://stevestedman.com/2012/04/using-a-cte-to-split-a-string-into-rows/ At the time, I thought it was pretty handy …

CTE to Split a String in a function SplitString Read more »

Last week I had the great opportunity to speak at PASS Summit 2015. My presentation was on Common Table Expressions.   Here is the sample code from the presentation. AdvancedCTEs.zip   Related Links: Common Table Expression (CTE) Month at SteveStedman.com (introduction) …

Epic Life Goal Completed: Speaking at PASS Summit – Advanced CTEs Read more »

Max Server Memory Setting Explained If you have more memory than your database and applications on the SQL Server will ever use than this is not a problem, but when you run into memory constraints this setting is much more …

Max Server Memory – SQL Server Read more »