Tag Archives: Performance

The SPU

Ever since I heard about the SQLOS and all the work that went into producing an operating system for SQL Server inside of the host OS, I’ve thought that perhaps there might be value in specializing the environment for a … Continue reading

Posted in Editorial | Tagged , | Comments Off on The SPU

The Growth of IQP

When Microsoft started to talk about Intelligent Query Processing (IQP) before SQL Server 2017, I wasn’t sure what to think. There was a diagram with 20 things on it, and only 5 were highlighted (you can see that in the … Continue reading

Posted in Editorial | Tagged , | Comments Off on The Growth of IQP

The Need for 256GB

I have seen a few people call for raising the RAM limit in the Standard Edition of SQL Server. In 2016, Aaron Bertrand voiced this, and for 2019, Glenn Berry asked that the limit be raised to 256GB. In the … Continue reading

Posted in Editorial | Tagged , , | 5 Comments

The PASS Pro Videos are Live

The PASS Pro program was an interesting educational opportunity that came out last year. A number of people subscribed, including me. I did this more to support the org than for the content, but I did want to watch the … Continue reading

Posted in Blog | Tagged , , , , , | Comments Off on The PASS Pro Videos are Live