For the SQL Lycan in us all

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[…]

SQL Saturday #517 Philadelphia

I am honored to be accepted to speak and return Philadelphia, PA on Saturday, June 04, 2016.  Along with seeing great #sqlfamily and being able to share what I can from a hopefully unique perspective. I will be discussing Common T-SQL Coding mistakes and referencing SARGability and RBAR. As database code tuners, we may get Read more about SQL Saturday #517 Philadelphia[…]

SQL Saturday #486 Richmond

I am honored to be accepted to speak and return Richmond, VA on Saturday, March 19, 2016.  Along with seeing great #sqlfamily and being able to share what I can from a hopefully unique perspective. I will be discussing Service Broker from the perspective of coaching/playing football.  Let’s see how we can relate Service Broker Read more about SQL Saturday #486 Richmond[…]

Deadlocking – Deciding which child gives up what they want

As we have spoken about before, parents of siblings or the siblings themselves understand what it is like for a parent to have to resolve a squabble.  Recently, my daughters were having burgers for dinner.  My youngest was sitting at the table with the ketchup and my eldest had both hers and her sister’s burger. Read more about Deadlocking – Deciding which child gives up what they want[…]