The SQL Server Interview Questions and Answers Complete List Download collects my six part series in one PDF, as many readers asked.
Silent Truncation When Building Strings in nvarchar(max) Variables
Silent truncation can happen while SQL Server evaluates a bounded expression. These examples compare the lost characters with a max expression and a max REPLICATE input. Check stored lengths before blaming a clipped display.
SQL SERVER – CASE Statement/Expression Examples and Explanation
The CASE Statement/Expression works anywhere an expression can, from the SELECT list to WHERE and HAVING. Here are its two basic forms with examples.
SQL SERVER – Stored Procedures Advantages and Best Advantage
My take on stored procedures advantages, and the best one of all: execution plan retention and reuse, since the rest can be had without them.
SQL SERVER – Fix : Error 1702 CREATE TABLE failed because column in table exceeds the maximum of columns
Error 1702, CREATE TABLE failed, happens when a table goes past the 1024 column limit in SQL Server 2000. The fix is to cut the columns to 1,024 or fewer.
SQL SERVER – Performance Optimization of SQL Query and FileGroups
My tips on transaction log placement, FileGroups for tables and non-clustered indexes, database size and autogrow settings for better SQL Server performance.
SQL SERVER – SQL Commandments – Suggestions, Tips, Tricks
My 20 SQL Commandments for SQL Server, rewritten from an Oracle article: know your data, test with realistic data, write identical statements, and more tips.