Cardinality Estimator Archives - The SQL Nomad

Have Database, Will Travel

Archives

When the Student is Ready, The Teacher Will Appear


This week I ran into a problem I’d never experienced in 20 years of working in SQL Server. A query that had run perfectly fine in an old version of SQL Server (2008R2 to be precise) suddenly became the slowest query on earth in a new edition (SQL Server 2016). The two servers were comparable…

Read More

  • Subscribe!

    Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 348 other subscribers

  • Topics