How NASDAQ moved its market data system from mainframes to SQL Server 2005, handling about 5,000 transactions per second at market open.
SQLAuthority News – Book Review – Pro T-SQL 2005 Programmer’s Guide (Paperback)
My review of Pro T-SQL 2005 Programmer’s Guide by Michael Coles, a practical book on SQL Server 2005 T-SQL from a developer’s view, easy for beginners too.
SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database
Keys are critical to any database. This script finds every table with a foreign key constraint in SQL Server 2005, with its column and the referenced table.
SQL SERVER – T-SQL Script to Attach and Detach Database
Move a database to a new server in three steps: Detach Database with sp_detach_db, copy the data and log files, then attach it again with CREATE DATABASE.
SQL SERVER – T-SQL Script to Insert Carriage Return and New Line Feed in Code
Add a carriage return with CHAR(13) and a New Line Feed with CHAR(10) in T-SQL. Handy for formatting output, dynamic SQL with GO, and saving user text.
SQL SERVER – 2008 – Book On-Line Link – BOL
The SQL Server 2008 Books Online link, also known as BOL, plus the SQL Server 2016 docs. BOL is the first place I check before I look anywhere else for help.
SQL SERVER – 2005 – Find Stored Procedure Create Date and Modified Date
A simple script on sys.objects that shows the stored procedure create date and modified date, handy for audits and for watching changes to your objects.