First introduced in SQL Server 2012, columnstore indexes can give you major performance ... or a handful of pages in a database is called a seek in most database engines. It is very efficient ...

In part 1 of my SQL Server 2022 features series, you learned about the improvements to the cardinality estimator component of query optimization. In this installment, you will learn about another ...

In SQL Server 2022, we have a new IS DISTINCT FROM and IS NOT DISTINCT FROM syntax that not only handles both NULL and non-NULL values, but allows the execution plan to use an index seek ...

In fact, a view really doesn’t do anything until you query it. In SQL Server 2000 and 2005, you have the ability to add indexes to views. But, if a view is just a stored query definition in the ...