Is your feature request related to a problem? Please describe.
If we're doing index tuning, we also want the index creation scripts to leverage whatever options exist for our SQL Server version and edition (or Azure SQL DB).
Describe the solution you'd like
In the prompt generated with the @ai parameter, include advice to the AI explaining versions like this:
When creating indexes, use online options and wait-at-low-priority if possible on this database, which is running on SQL Server 2022 Standard Edition.
Is your feature request related to a problem? Please describe.
If we're doing index tuning, we also want the index creation scripts to leverage whatever options exist for our SQL Server version and edition (or Azure SQL DB).
Describe the solution you'd like
In the prompt generated with the @ai parameter, include advice to the AI explaining versions like this: