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.
LIKE, No Way! On August 22, 2011August 22, 2011 By John Morehouse Have you ever used a tool for ever and a day, and then suddenly one day, you discover that there is so much more that single tool can do? Well, that happened to me. In this post I talk about the popular ‘LIKE’ function and it’s other uses.
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!