View Event: SQL Assessment – Microsoft’s Best Practices Checker Do you want to get the current 244 suggested best practices from the SQL Server Team and evaluate your environments? These best practices are available for all instances, from your Data Center to the cloud. In this demo session (Yes, no slides), I will show you […]
View Event: Query store hints demo Query Store hints feature provides an easy-to-use method for shaping query plans without changing application code. This feature is a member of the Intelligent Query Processing family. In this demo-only session, I will show how to use and take advantage of Query Store hints.
View Event: Think like the Cardinality Estimator SQL Server uses a phase during query optimization, called cardinality estimation (CE). This process makes estimates based on the statistics as to how many rows flow from one query plan iterator to the next. Knowing how CE generates these numbers will enable you to write better TSQL code […]
View Event: New features in Management Studio — Performance Troubleshooting made easier! SQL Server Management Studio (SSMS) is now updated each month with the latest version of the SQL Client Tools, enabling rapid enhancement to the Execution Plan. Do you know that now you can see how many pages are spilled to disk for a […]
View Event: The magnificent seven – Intelligent Query Processing in SQL Server Is there a way to fix query performance issues without any code changes? Making application changes can be an expensive undertaking. Hence, developers and DBAs want the query processor to adapt to their workload needs vs. using options and trace flags to gain […]
