In every new version of an application, there are three basic improvements: (1) Revolutionary new features, (2) Evolution of something that's been in previous versions, and (3) Bug fixes. In this short article we will focus on differences that are a result of different versions. Different SQL Server versions (service packs, CUs).Different SQL Server Instance configurations (MAX DOP, etc.).Different server settings (regional settings, Power Plans, etc.).Different DDL and/or DML (data, indexes, statistics, fragmentation, etc.).Different server hardware (Number of CPU, Memory size, slower or a busier disk, etc.).Basically, the main reason for a different execution is a different execution plan, and there are several scenarios where we might get a different execution plan, like for example: The same query with different results?!? How can it be? There are too many variables to answer a general question like, 'Why is the same query executed differently in two different databases?' (for example, it's much slower in one database, or it costs many

Sql server versions