Varchar PrimaryKey. Clustered or nonclustered?
136937
When should a primary key be declared non-clustered?
63140
SQL Server nvarchar(max) vs nvarchar(n) affects performance
138284
Are individual queries faster than joins?
155620
Size of VARBINARY field in SQL Server 2005
127800
SQL: Using NULL values vs. default values
23439
Why use an int as a lookup table's primary key?
26686
What are the use cases for selecting CHAR over VARCHAR in SQL?
133157
mysql varbinary vs varchar
92967
Is there a "Default Order By Column" in SQL Server?
100461
When or why would you use a right outer join instead of left?
83443
When should I use semicolons in SQL Server?
74192
Is storing a delimited list in a database column really that bad?
72450
Clustered Index Misunderstanding
19436
LinqToSql .Contains and nvarchar vs varchar parameters -> index conversion plan
28484
SQL Server indexes - ascending or descending, what difference does it make?
135864
Does column ordering affects performance in Microsoft SQL Server 2012?
113989
Why doesn't SQL Server CE support varchar?