We’ve recently looked at how single threaded concurrency was handled in SQL Server and followed up last time by diving into multithreaded concurrency. This time we’re going to go a bit further with the multithreading to look more into how the contention is handled when the number of cores available doesn’t line up with our workload. We’ll also […]
Month: Oct 2023
Multithreaded Concurrency Essentials
Recently we looked at single threaded concurrency in SQL Server for workloads which only need a single core to execute. We saw how they ran at the same time with the queries effectively being round-robined on the CPU. This time out I wanted to look at how the concurrency looks when we’re working with multithreaded workloads. Setting […]
Markdown Cheat Sheet
If you haven’t seen or used Markdown before, it’s a simple way to annotate plain text in a way which indicates formatting by using specific characters. This means that you can format your text as you’re typing rather than scrolling through countless options in a visual editor such as Word. Personally I find markdown so […]
Partial Highlighting in Notepad++
Productivity is a core component of our day to day jobs in and around code. Part of that comes from the tools we use and a common one would be Notepad++ thanks to all of its handy features and plugins to extend it. One of the simplest out of the box features is the ability […]
The question for today: if we have three queries – one which takes 1 second to run, one which takes 2 seconds to run, and one which takes 3 seconds to run – how long will it take to return data for the first and last query if they all start at the same time? […]