In this post I’m going to look at the new feature of SQL Server’s 2019 Database Engine – Batch Mode on Row Store. I start with a quick introduction and then look at some curious details, that I have found playing with this feature so far. At the moment of writing this post I use the last public version of SQL Server – SQL 2019 CTP 2.0.
Read…
Yearly Archives: 2018
Troubleshooting with windows debugger
There is a lot of information about how SQL Server works: documentation, books, blogs etc. But sometimes you can’t find the information you need. Windows Debugger (WinDbg) and public debug symbols might be helpful in this case. I usually use them for learning about how does the Query Processor work. However, this post is not about query processing.
In this post I’m going to share a real-world example from my recent practice where some of the internal’s knowledge helped me to reveal the problem and make a quick fix. I hope you find this small investigation interesting.
Read…