SQL Server 2014

The Real SQL Server 2014 Power Feature (It May Not Be Hekaton)

by

Just a quick post today to tell you about a webinar I am doing on the 27th of August, 2014. The title is “The Real SQL Server 2014 Power Feature (It May Not Be Hekaton)”, and it is me talking about the new cardinality estimator (CE) in SQL Server 2014. You might recall that earlier … Read more

HOW TO: Find Currently Running Long SQL Agent Jobs

by

A while ago I had posted a script to help find jobs that were currently running longer than expected. Since I’ve been sharing some scripts recently, I decided to verify that this script still works for finding long running jobs in SQL Agent for SQL Server 2014. Why This Script Matters Because you want the opportunity … Read more

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

by

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 … Read more

SQL 2014 Cardinality Estimator: Why You Should Care

by
SQL Server 2014 Cardinality Estimator

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 … Read more

Estimating Hekaton Max Server Memory Requirements in SQL Server 2014

by
Hekaton memory effect on buffer pool

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 … Read more

+ More