HOW IT WORKS: SQL Server Scheduler AffinityMoved from: bobsql.com SQL Server uses 3 types of affinity to control where the SQL Server worker […] 5 février 2022 dans Sites Microsoft par MS Tech Community
How It Works: SQL Server Stack Trace – COMDAT EliminationMoved from: bobsql.com Starting with SQL Server 2019, SQL Server is built with the COMDAT, ICF linker option enabled, reducing size/space usage. For […] 5 février 2022 dans Sites Microsoft par MS Tech Community
How It Works: XEvent String Comparison Performance TipMoved from: bobsql.com I ran across a check in the XEvent string comparison logic which can be used to improve performance of the ‘like’ comparison. At […] 5 février 2022 dans Sites Microsoft par MS Tech Community