“What will be the order of the result set of a SELECT statement on clustered indexed table when the ORDER BY clause is not used?”
SQLAuthority News – NASDAQ Uses SQL Server 2005 – Reducing Costs through Better Data Management
How NASDAQ moved its market data system from mainframes to SQL Server 2005, handling about 5,000 transactions per second at market open.
Writing T-SQL Somebody Else Can Maintain
Write maintainable T-SQL with clear names, explicit results, focused procedures, and comments that explain the business reason behind the code.
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.
The SQL Basics Almost Everybody Skips
Revisit SQL basics that change query results: NULL logic, logical processing order, grouped filters, and the difference between two common counts.