Michael Bourgon sets ANSI_PADDING: We know that SQL Server can cache multiple query plans for the same query based on the SET_OPTIONS for that query,…
Michael Bourgon sets ANSI_PADDING:
We know that SQL Server can cache multiple query plans for the same query based on the SET_OPTIONS for that query, and that SSMS doesn’t have the same options as the standard library. (https://www.sommarskog.se/query-plan-mysteries.html). He even includes a chart!
My initial comment was “Michael Bourgon sets XACT_ABORT” but that’s actually not one of the list, so I had to change it for the sake of correctness even though I think it was funnier in its original guise.
| # | Наименование новости | Тональность | Информативность | Дата публикации |
|---|---|---|---|---|
| 1 | A Primer on Database States | 0 | 5 | 14-07-2026 |
| 2 | SQL Login Overhead in SQL Server 2025 | 0 | 2 | 13-07-2026 |
| 3 | Ways to Find a Query Plan | 3 | 2 | 14-07-2026 |
| 4 | Linux Cache Aware Scheduling Extended For Even Better Performance: Up To 360% In MySQL | 7 | 8 | 25-06-2026 |
| 5 | Bad Query Signals | 0 | 2 | 14-07-2026 |
| 6 | Performing a Lakehouse Table Health Check | 0 | 5 | 13-07-2026 |
| 7 | Writing Semantic Model Column and Measure Descriptions | 0 | 5 | 14-07-2026 |
| 8 | Dealing with linger.ms in Apache Kafka | 0 | 5 | 14-07-2026 |
| 9 | Applying Different Formatting Rules at Levels of a Hierarchy | 0 | 5 | 14-07-2026 |
| 10 | What is the HTTP QUERY method? | 0 | 8.76 | 29-07-2026 |