The theme for this time is SQL "execution plans."Execution plans are one of the technologies you absolutely must understand when considering database performance.However, this content might also be a ...

One of the challenges IT and database administrators confront when implementing disaster recovery provisions is choosing from among the myriad options available. Existing high availability ...

Maintaining a SQL Server environment is a potentially complex endeavor. Here are 10 tips for ways you can minimize complexity and reduce stress. Based on my SQL Server consulting practice, here are ...

In earlier versions of SQL Server, after selecting a join algorithm, SQL Server had to process it even if a better alternative might be available. In SQL Server 2017, the query optimizer can now sense ...

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 ...

A popular performance tuning book gets updated for SQL Server 2022, how does it fare? This well-liked SQL Server book examines performance from various angles, but concentrates on improvements related ...

SQL Sentry, LLC., the developer of award-winning software for SQL Server performance monitoring and tuning, is pleased to announce that all Plan Explorer features are ...

I'm not sure it really is actually estimated because as far as I know the only way it can show you what the query plan is is by executing it. So then it really isn't an estimate. I'm sure I'm totally ...