(Pinal Dave) Yes, it is true that from SQL Server 2016, Trace Flag 1117 and 1118 are not required. Recently I was hired by a large banking firm to help them with the Comprehensive Database Performance Health Check.

(Grant Fritchey) I absolutely love Query Store and the ability it provides to force a plan is amazing. However, there are a lot of little gotchas in this functionality.

(Manoj Debnath) In SQL cursors serve as a pointer that enables application programming language to deal with query results one row at a time.

(Sergey Gigoyan) In SQL Server databases with actively running transactions, it is a common situation when more than one transaction tries to modify the same data simultaneously. In such instances, SQL Server deadlocks are often quite possible, which can be a real issue in terms of performance.

(Jason Brimhall) Have you ever run into an error like this? Cannot resolve the collation conflict between “pick a collation” and “pick another collation” in the equal to operation.

(Kenneth Fisher) After my post last month about configuring your tools I’ve been on a make my life easier kick and one of the things that gives me grief every day is that my eyesight is at best mediocre and some days it’s worse than others.

(Pinal Dave) Sometimes I get amazed by the speed at which the search engine crawls and gets the right results. A few days ago, I wrote a blog about a UI error in Always On availability group.

(K. Brian Kelley) I am working with a system that doesn’t allow for NULLs in the SQL Server data model. However, I have clear cases where I’m missing information. For instance, I’m dealing with building out our academic system into a new platform and we have columns for final grade in a course as we

(Pinal Dave) At SQL Authority, my main job is to work with SQL Server Performance Tuning, and every day I learn that more organizations are implementing DevOps for their database platform.

(Paul White) Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. It looked at ways to find a relatively small number of distinct values from a moderately large dataset, and concluded that a recursive solution could be optimal.