My Index Optimization checklist for Jr. DBAs: index columns used in WHERE, ORDER BY, GROUP BY and JOINs, drop indexes you do not need and keep keys small.
SQLAuthority News – Author Visit – The 2007 Marketing Innovation Summit, Las Vegas
Notes from the 2007 Marketing Innovation Summit in Las Vegas, arranged by Unica: the agenda, the industry leaders I met and a few SQLAuthority.com readers.
SQL SERVER – Top 10 Hidden Gems in SQL Server 2005
Top 10 Hidden Gems in SQL Server 2005 from a TechNet paper by Cihan Biyikoglu: TableDiff.exe, logon triggers, forced parameterization, vardecimal and more.
SQL SERVER – 2005/2000 Examples and Explanation for GOTO
How the GOTO statement jumps to a label in the same T-SQL batch. My explanation for GOTO covers the syntax, the rules and when I still use it.
SQL SERVER – Creating Comma Separate Values List from Table – UDF – SP
Three ways to build a Comma Separate Values List from a table: COALESCE, a smart SELECT, or a cursor. Written for SQL Server 2005 with VARCHAR(MAX).
SQL SERVER – UDF – Function to Convert List to Table
A UDF, udf_List2Table, to convert list to table with any delimiter you choose. Written for SQL Server 2005 with VARCHAR(MAX), and easy to adapt for 2000.
SQL SERVER – 2005 Enable CLR using T-SQL script
In SQL Server 2005 the CLR is off by default. Here is the sp_configure script to enable CLR, turning on show advanced options and then clr enabled.