Unlocking the Power of the KEEP PLAN Query Hint in SQL Server
Learn how to use the KEEP PLAN query hint in SQL Server to prevent unexpected query recompilations and maintain stable performance.
Supercharging SQL Server Query Performance with Trace Flag 8649
Learn how to dramatically improve SQL Server query performance by forcing parallelism with trace flag 8649 in this step-by-step guide.
Read moreUnlocking the Secrets of SQL Server Memory Grants
Learn what the MemoryGrant property in query plans means and how it impacts performance!
Read moreDatabase Watcher: Monitoring for Azure SQL
Learn how the new database watcher service enables easy, in-depth performance monitoring for Azure SQL Database and Managed Instance.
Read moreSimplify SQL Queries with the OVER Clause
Learn how to use SQL Server’s OVER clause to simplify queries that use window functions like ROW_NUMBER, RANK, SUM, AVG and more.
Read moreBeware of Pitfalls with Cross-Database Queries at Different Compatibility Levels
Learn about potential issues that can arise when running cross-database queries between SQL Server databases at different compatibility levels.
Read moreOptimizing SQL Server Performance with TSQL_SCALAR_UDF_INLINING
Learn how to boost SQL Server performance using TSQL_SCALAR_UDF_INLINING. Discover when to enable or disable this feature for optimal results.
Read moreShould You Clear SQL Server Wait Stats After Raising Database Compatibility Level?
Learn whether clearing SQL Server wait stats is necessary after raising your database compatibility level and how it impacts performance tuning.
Read moreCopilot in Azure SQL Database
Azure SQL Database introduces Copilot in private preview, enhancing database management with natural language to SQL and integration with Microsoft Copilot.
Read moreCan Inequality Columns Ever Lead a SQL Server Non-Clustered Index?
Learn when it’s okay for an inequality search column to lead a SQL Server non-clustered index, boosting query speed. See examples & get indexing tips!
Read more
You must be logged in to post a comment.