if exists (select* from sys.indexes i where i.[object_id] = object_id('AKUZ.T_ENTRY_HISTORY', 'U') and i.name = 'IX_T_ENTRY_HISTORY_TicketID')
drop index IX_T_ENTRY_HISTORY_TicketID ON AKUZ.T_ENTRY_HISTORY
go
	CREATE INDEX [IX_T_ENTRY_HISTORY_TicketID]  ON [AKUZ].[T_ENTRY_HISTORY] (TicketID)	 INCLUDE (EntryHistoryID) WHERE [TicketID] IS NOT NULL WITH (FILLFACTOR=95, SORT_IN_TEMPDB=ON);
go