nvarchar(max) versus nvarchar(n) in table variable columns
110644
Are there any disadvantages to always using nvarchar(MAX)?
37319
What is the most efficient way to concatenate strings in SQL Server?
148321
SQL Server Maximum and Minimum memory configuration
64944
How to use LIMIT keyword in SQL Server 2005?
35978
Using MAX in SQL Expression of ArcMap ModelBuilder
66324
Performance of string comparison vs int join in SQL
140189
LEN function not including trailing spaces in SQL Server
142073
Can I pass column name as input parameter in SQL stored Procedure
141717
Dynamic SQL to generate column names?
155717
Max of a table/list with indeterminate values
34096
LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
34438
Column name or number of supplied values does not match table definition
39592
Are there disadvantages to using VARCHAR(MAX) in a table?
85667
T-SQL Cast versus Convert
81344
Stored Procedure: table-Value parameters
129683
How can I prefix all column names in a T-SQL function?
62267
MySQL stored procedure vs function, which would I use when?