Thanks!

I would like to recall this post. I was running under wrong database.

Thanks a lot.

[Col1] ASC,

[Col2] ASC,

[Col3] ASC,

[Col4] ASC

Majority of the queries use all these...

Table/columns are renamed due to security reasons.

Please see the table structure:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Test](

[Id] [int] IDENTITY(1,1) NOT NULL,

[Col1] [varchar](256) NOT NULL,

[Col2] [varchar](256) NOT NULL,

[Col3] [varchar](256) NOT NULL,

[Col4] [int] NOT NULL,

[ColumnValue] [varchar](max)...

Any downside if the clustered key(non-primary key columns) is not unique and the columns are VARCHAR fields and NOT NULL?

Or is it better to create Primary key (identity key)...

Phil Parkin (7/8/2016)

---

Grant Fritchey (7/8/2016)

---

I'm in agreement with Kevin.

Since the clustered index defines data storage, I recommend that the cluster be the most commonly used path to the storage. If...

Does the clustered key column(s) has to be NOT NULL/UNIQUE as best practice?

Thank you!

Thanks Grant.

Thanks Lowell

Thanks, I will post the table info/spreadsheet.

Auto close is set to off.

curtkrueger (5/4/2016)

---

I had this issue before, and it was due to me not using the fully qualified domain name when using VPN.

For example, our domain is xyz but on the...