Filtered Statistics

Filtered Statistics For me, tuning the Microsoft Data Platform and SQL Server is a simple principle, make the engine do as little work as possible. For the engine and the optimizer to be able to do so, we need to feed it the appropriate information. The SQL Server Cardinality Estimator(CE) does it’s best to analyze Read more about Filtered Statistics[…]

Buffer Pool Extension

Working with Buffer Pool Extension There are many limitations to the SQL Server Standard Edition Database Engine.  In my opinion, one of the most confining is the memory limitation.  Many of us know the Page Life Expectancy counter, but why is this important?  For SQL Server to deliver data to you, the data is read Read more about Buffer Pool Extension[…]