Query Optimizer Wins Again On April 17, 2014March 15, 2015 By John Morehouse A quick look at why the Query Optimizer was correct in stopping me in my tracks.
Configuring Max Memory for SQL Server On March 3, 2014September 24, 2020 By John Morehouse A look at a script that validates the max memory setting for our installed SQL Servers.
Add A Procedure to Master Database? Yes Please! On October 21, 2011June 23, 2012 By John Morehouse In this post I talk about adding a procedure to the master database so that you can access it regardless of which database you are located in.
T-SQL To The Rescue for Puzzle Friday! On March 21, 2011March 21, 2011 By John Morehouse Answers to the puzzle friday question and how I solved it with a little bit of T-SQL code.
Puzzle Friday! On March 18, 2011March 18, 2011 By John Morehouse It’s puzzle Friday at work and this week’s puzzle can be solved by some T-SQL. Take the puzzle and see if you can come up with another solution!