implications of using nvarchar(max) with non-indexed fields
39592
Are there disadvantages to using VARCHAR(MAX) in a table?
12846
Is there a good reason to use upper case for SQL keywords?
90430
What is the maximum number of characters that nvarchar(MAX) will hold?
73508
RDBMS: Proper way to store data - comma separated variables or in different fields or tables?
8161
How do I create a stored procedure that will optionally search columns?
26686
What are the use cases for selecting CHAR over VARCHAR in SQL?
152578
Should you choose the MONEY or DECIMAL(x,y) datatypes in SQL Server?
44138
Why is SQL Server 2012 Recommending This Index Be Created?
4877
Is a composite index also good for queries on the first field?
16236
Is it possible to enforce unique values in a column, excluding nulls?
127800
SQL: Using NULL values vs. default values
64024
Strings as Primary Keys in SQL Database
136937
When should a primary key be declared non-clustered?
58304
Why are queries parsed in such a way that disallows the use of column aliases in most clauses?
102004
MySQL: Large VARCHAR vs. TEXT?
86508
What are the pros and cons to keeping SQL in Stored Procs versus Code
37319
What is the most efficient way to concatenate strings in SQL Server?