Learn how to optimize SQL queries for NULL values by following some best practices and techniques, such as using IS NULL or IS NOT NULL operators, avoiding NOT IN with NULL values, and more.

Also, check if the same thing happens on other databases, i.e. whether this should be a SQL Server-only change or something with a wider scope. SQL Server documentation detailing all the above, plus ...

Query Store is one of the most powerful database-scoped features in SQL Server for troubleshooting performance and improving the stability of your database.

I've been in an argument with one of our devs that took an update statement with an inner join and made it a left join (because inner was missing some records somehow in the left table - tableB in ...

In SQL Server 2017, when the query optimizer encounters code with a multi-statement TVF, the query optimizer will pause optimization, execute the TVF subtree to get a very accurate cardinality ...

Implement ISNULL variant of COALESCE which takes only 2 arguments and is used by MS-SQL server. Relates to #34956 ...

In recent years, Massively Parallel Processors have increasingly been used to manage and query vast amounts of data. Dramatic performance improvements are achieved through distributed execution of ...

I have a test server hosting several sites using SQL Server Express and SQL Management Studio Express. I've seen one site have an occasional issue where queries to a particular table (the ...