Silent installation of SQL Server 2005 in two steps: an .ini file built from template.ini, then setup.exe with /qn or /qb. Plus tips to test it.
SQL SERVER – SP Performance Improvement without changing T-SQL
Two easy ways to improve SP performance without changing T-SQL: do not prefix stored procedures with sp_, and call them by the fully qualified dbo name.
SQL SERVER – 2005 Reserved Keywords
SQL Server 2005 Reserved Keywords are part of the T-SQL grammar, so avoid them as object names. If you must use one, you need delimited identifiers.
SQL SERVER – Search Text Field – CHARINDEX vs PATINDEX
CHARINDEX and PATINDEX both return the start position of a pattern in a text field. PATINDEX allows wildcards, CHARINDEX does not. Examples use AdventureWorks.
CHOOSE: Handle Indexes Outside the List
CHOOSE returns an item from a positional list. Check unsupported indexes and compare a consistently typed CASE expression with an explicit fallback.
SQL SERVER – Fix: Server: Msg 7391, Level 16, State 1, Line 1
Msg 7391 has no single fix. I list the causes I have hit on my servers, from distributed transactions on linked servers to DTC firewall settings, to try one by one.
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.