I’ve said it before but it bears repeating: I work with some amazingly creative people these days. Happy Sysadmin Day!
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(…)
When Google was founded in September of 1998 it’s mission was simple enough: “to organize the world’s information and make it universally accessible and useful”. They did this by creating what we now know as the PageRank algorithm, but was first called “BackRub“, in an attempt to create a better search engine than what AltaVista, Ask(…)
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(…)
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(…)