Month: Oct 2020

SQL

Commenting with Care

Post author By Andy B.
Post date Oct 25, 2020
No Comments on Commenting with Care

Comments are a wonderful thing whether it’s keeping track of your thoughts in a drawn out stored procedure, or leaving some breadcrumbs to follow when revisiting code in the future. There is, however, a slightly uglier side to these when you’re trying to look at queries as they run. Let’s suppose we’re running a very […]

SQL Server

A Story of Memory Pressure in SQL Server

Post author By Andy B.
Post date Oct 11, 2020
No Comments on A Story of Memory Pressure in SQL Server

Recently there was a question of why a query runs under a second on one environment and another environment runs the same query for 90 seconds and times out the application. It was observed the memory on the second system was running at 94% and so it was put down to that and ‘get more […]