I was going through some old files recently and I came across a folder that was essentially a junk drawer of scripts I’ve put together over the years. I don’t know what to do with most of them now. For example, the isql scripts for some Sybase ASE 11.5 instances aren’t very helpful for many these(…)
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(…)