MSSQL
VM Snapshots and Performance or: How I Learned to Love My Martian Data Center
Snapshots and checkpoints are fine tools for you to use, but when you are done with them you should get rid of them, especially for a database server.
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 … Read more
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 … Read more
Coffee Perceptions
I’ve written before about the idea of parallax with regards to your career. But parallax, or perceptions, can be applied to anything. Just for fun, let’s think about the different perceptions we can have regarding a cup of coffee. The classic perception, of course, would be “do you see the cup as half-full or half-empty”. … Read more
Estimating Hekaton Max Server 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 … Read more
