SQL MCM

SQL 2014 Cardinality Estimator: Why You Should Care – Part 2

SQL 2014 Cardinality Estimator: Why You Should Care – Part 2

In the previous post I talked about how query optimization works, the role the Cardinality Estimator (CE) plays, and why you should care. Today I am going to break down some of the details about the differences between the old and new CE, as well as show some examples and scenarios. What’s New in the SQL 2014(…)

SQL 2014 Cardinality Estimator: Why You Should Care

SQL 2014 Cardinality Estimator: Why You Should Care

This is the first of two posts on the new Cardinality Estimator in SQL Server 2014.  SQL Server 2014 comes with a lot of shiny things. Hekaton (or as Microsoft Marketing likes to call it, In-Memory OLTP), updateable Columnstore indexes, and buffer pool extensions are some of the more common enhancements. All of those new(…)

Estimating Memory Requirements in SQL Server 2014

Estimating Memory Requirements in SQL Server 2014

SQL Server 2014 has a lot of shiny new features. One of the brightest is In-Memory OLTP Hekaton, something I have been optimistic about (get the pun?) ever since I saw it at the PASS Summit in 2012. These days there is no shortage of information available to day regarding how Hekaton is full of(…)

Upgrading to SQL Server 2014: A Dozen Things to Check

Upgrading to SQL Server 2014: A Dozen Things to Check

Here we go again! It seems that it was only yesterday we were talking about all the things you want to look out for when upgrading to SQL Server 2012. Now, just two years since SQL Server 2012 was released, we have a shiny new version with SQL Server 2014. And that means, of course,(…)

What’s Worse Than a NULL? An Incorrect NULL

What’s Worse Than a NULL? An Incorrect NULL

Recently it was brought to my attention that the query_hash and query_plan_hash columns inside of sys.dm_exec_requests were returning NULL values. I think everyone knows how I feel about NULLs already, but this was slightly more concerning. See, I work for a company that makes this wonderful tool called Database Performance Analyzer (DPA), and we rely(…)

Load More