Two convenient SQL Server 2008 features: inline assignment with DECLARE @idx INT = 0, and inline operations like SET @idx += 1. Fewer lines than before.
SQL SERVER – Compound Assignment Operators – A Simple Example
SQL Server 2008 added Compound Assignment Operators like += and *=, which change a variable and assign it on one line. A simple example and the full list.
SQL SERVER – Find Table in Every Database of SQL Server – Part 3
Part 3 of Find Table in Every Database: Greg Steinkuhler shares a stored procedure that also searches servers across the network, where sp_msforeachdb could not.
SQL SERVER – Create Database Error in Windows Vista
A reader on Vista got a create database error, Msg 262 CREATE DATABASE permission denied in database master. The fix is the same one from my earlier post.
SQL SERVER – 2005 – Connection Strings For .NET
SQL Server 2005 connection strings for .NET, ODBC and OLE DB with SQL Native Client: standard security, trusted connection and named instance examples.
SQL SERVER – Microsoft SQL Server 2000/2005 Management Pack Download
The SQL Server Management Pack monitors availability and performance of SQL Server 2000 and 2005, raises alerts for configuration problems and suggests resolutions.
SQL SERVER – Simple Puzzle Using Union and Union All
A simple puzzle using UNION and UNION ALL: guess the output of two short scripts before you run them. The hint is my article on UNION vs. UNION ALL.