SQL Server Plan Cache Bloat

Plan Cache bloat is generally bad – it wastes CPU, it wastes memory. Plan Cache bloat happens when SQL Server stores multiple query plans for seemingly identical queries….except they’re not identical. Let’s look at an example. Before we begin, let’s ditch the plan cache as this will help highlight the impact of our code. DON'T … Continue reading SQL Server Plan Cache Bloat

Advertisements

SQL Server and GDPR, what should you be doing?

SQL SERVER…..GDPR…..ONE OF THESE IS MY FAVOURITE THING TO BLOG ABOUT….THE OTHER IS GDPR. Fortunately, this blog isn’t about GDPR! It’s about SQL Server, or more specifically, how to secure your data in SQL Server. However, if you care about GDPR (and let’s face it, we’re constantly told we should!) and you happen to have … Continue reading SQL Server and GDPR, what should you be doing?

SQL Server – Clustered vs Non-clustered indexes

A question was asked on LinkedIn (https://www.linkedin.com/groups/137774/137774-6171222761881600002) regarding the difference between clustered and none-clustered indexes. Since LinkedIn limits the characters you can enter, I'm posting my (hastily written) reply here. I often explain it to SQL newbies using the example of a dictionary vs store catalogue. Let's say you pick up a copy of the … Continue reading SQL Server – Clustered vs Non-clustered indexes

SQL Server – Why a Table-Valued function could be killing your performance

In this blog I'm going to walk you through a serious SQL Server performance problem I had in a customer's production environment. Turned out that although the results were good, a miss-behaving table-valued function in one query was executing thousands of times more than necessary, and killing the performance. The code, as I found it, looked like … Continue reading SQL Server – Why a Table-Valued function could be killing your performance

Getting started with the Raspberry PI, PIFace and Scratch.

I've just gone through the slightly torturous process of setting up my Raspberry PI (RPi) and PiFace. For my own reference, and for others, here's list of useful resources. Hopefully this will give you all the pieces of the 'Pi' that you need (sorry!!!). Good setup guide  Setting up your PiFace  Enabling Mesh in Scratch (allows … Continue reading Getting started with the Raspberry PI, PIFace and Scratch.