These questions (which all apply to SQL Server 2008) are not meant to be the only way to ascertain a candidate’s technical expertise during an interview, but rather one piece of the puzzle that ...

Joey on SQL Server A Deep Dive into SQL Server 2022's Query Performance Features, Part 1 An update to the cardinality estimator feature in SQL Server 2022 will be one of the biggest changes to the ...

As I suggested at the start of this column, sometimes it's your query's fault that it's running slowly. Sometimes it's not. You should, at least, make sure -- before you start tweaking your queries or ...

In SQL Server 2017, automatic plan correction was added, which allows for the database engine to automatically use the "last known good plan" for a query that has suddenly regressed in performance.

This wait type may also indicate the SPID is waiting for remote procedure calls, linked server queries, BULK INSERT commands, or full-search queries. PAGEIOLATCH_* —Buffer latches, including the ...