microsoft / tigertoolbox

Toolbox repository for Tiger team
http://aka.ms/sqlserverteam
Other
1.45k stars 734 forks source link

view_IndexCreation.sql has extra close bracket #295

Closed felixbrandt closed 1 year ago

felixbrandt commented 1 year ago

I'm having an issue where the generated SQL from view_IndexCreation.sql is creating a script with an additional close bracket when the suggestion has included columns.

Created query

USE [DatabaseName]
GO
IF EXISTS (SELECT name FROM sysindexes WHERE name = N'IX_TableName_71084') DROP INDEX [dbo].[TableName].IX_TableName_71084;
GO
CREATE INDEX IX_TableName_71084 ON [dbo].[TableName] ([Column1Name])
INCLUDE ([Column2Name], [Column3Name]));
GO
USE [DatabaseName]
GO
IF EXISTS (SELECT name FROM sysindexes WHERE name = N'IX_TableName_71084') DROP INDEX [dbo].[TableName].IX_TableName_71084;
GO
CREATE INDEX IX_TableName_71084 ON [dbo].[TableName] ([Column1Name])
INCLUDE ([Column2Name], [Column3Name]); -- removed extra bracket
GO

Table and column names changed for privacy.