Traditional SQL tuning requires DBAs and developers to understand the execution behavior (per an execution plan) in the database and try to modify the statement, or use an index, to improve its ...

Figure 1. Execution plan of a server query. As you can see in the above execution plan, SQL Server has highlighted a missing index that it thinks would help our query improve.

This processing is automatic and is apparent when viewing the execution plan in SQL Server Management Studio via the new Parallelism operator. Another new feature is partition elimination.

At Microsoft Build, SQL Server 2025 enters public preview with major enhancements in AI integration, performance, reliability and developer tools -- reaffirming Microsoft’s continued investment ...