I hadn’t been following the news much regarding SQL Server 2016, so when I did some reading the other day I was quite pleasantly surprised by some of the new features announced (not to mention that it looks like SSMS will finally be getting some much needed love). 🙂 We’ve been having some frustrating intermittent […]
Tag: performance
CURSORs and WHILE-Loops
Yes, I know this is a giant (some might say pointless, and I wouldn’t totally disagree) can of worms I’m opening here, but stay with me for a minute Why? We were discussing this at work a few months ago, and I was one of those people who followed “conventional wisdom” which says that SQL […]
Benchmarking I/O: The test rig
Work has been a little crazy lately, but I’ve still been wanting to do some I/O performance testing since we’re due to get some new servers in soon and I wanted to be able to compare apples with oranges. So this past weekend I decided to combine something I’ve been meaning to learn more about […]