Thursday 4 July 2013

Create NONCLUSTERED index in sql server

CREATE UNIQUE NONCLUSTERED INDEX [IX_TableName_FieldName]
ON [dbo].[TableName]
(
[FieldName] ASC
) WITH (IGNORE_DUP_KEY = ON) ON [PRIMARY]

No comments:

Post a Comment

Excel Sort values in ascending order using function TEXTJOIN

 Excel ::  Text ::  1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula ::     TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...