VM Snapshots and Performance or: How I Learned to Love My Martian Data Center

VM Snapshots and Performance or: How I Learned to Love My Martian Data Center

It takes a radio signal just about 1.28 seconds to get to the Moon (about 239,000 miles away), and about 2.5 seconds for round trip communication between our secret moon base and Earth. So, therefore this common SQL Server error message number 833… SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15(…)

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(…)

Load More