Paul Randal identified an issue in the SQL Server Missing Index DMVs (pre-SQL 2008R2) wherein they will, under the right wrong circumstances, recommend indexes that do already exist. This means that either missing is a subjective term or there is a bug in SQL Server 2005 and 2008. With the right people involved a great idea(…)
That’s right. We’re on a boat and Autotune is forbidden. So is Auto_Growth. But SQLCruise? What is SQLCruise? Is it a SQL Saturday afterparty? Is it a Tweet-up at sea? Is it a new training event unlike anything else that you’ve ever heard of? Kind of, sort of, and oh yes indeed! SQL Saturday(…)
#12 SELECT * Plain and simple this is a lazy habit that causes performance problems and possible code fail over the application lifecycle. That is all. “Explain myself” you say? Fine. Imagine you’re given a grocery list by your Significant Other that states: “Go to the Sunny Mart and buy everything. It’s exactly what we(…)