I have a primary users lookup table. I have userID and Domain used as composit key. I have following two different ways got from two different DBAs.
Script - 1
ALTER TABLE [dbo].[tbl_cv_user] ADD CONSTRAINT [PK_tbl_cv_user] PRIMARY KEY CLUSTERED
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 50) ON [PRIMARY]
ALTER TABLE dbo.tbl_cv_user ADD CONSTRAINT
PK_tbl_cv_user PRIMARY KEY CLUSTERED
) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
both are doing same thing overall, but still something not clear to me why they both have difference in script. Could you plz let me know which one to follow and which one will be best in terms of performance? we have almost 500000 records into it.