Filters

CXPACKET Is Wasting Your Memory

False Advice I will be honest here, at one point I had become a little blind to seeing CXPACKET waits on my SQL instances. As a DBA having to work across lots of different instances, you will see this quite a bit (or at least I have). Countless times had…

Batch Mode Fun

  Nuts and Bolts Deep within my little toolbox, is this little trick. Firstly, lets just set the record straight here, I don’t like little tricks, hacks and especially quick wins. However, with that said, sometimes you’re in a bind and you gotta get that query over the finishing line…

Extended Events

What are extended events? Extended Events first appeared with the release of SQL Server 2008. As a successor to the bulky and somewhat resource intensive SQL Profiler and SQL Trace tool, Extended Events was a new lightweight tool which can be used as and when required to gather useful metrics…

SQL Bits 2019

This year, i was lucky enough to attend SQLBits 2019 in Manchester England. This was my first time at SQL Bits and was keen to see what it had to offer, compared to other SQL events I have been to such as Data Relay. Through work, I signed up for…
Menu