How NASDAQ moved its market data system from mainframes to SQL Server 2005, handling about 5,000 transactions per second at market open.
SQL SERVER – Difference Between UPDATE and UPDATE() in Triggers
UPDATE changes rows in a table or view, while UPDATE() in triggers tells you if a column was part of an INSERT or UPDATE. Here is the difference.
SQLAuthority News – Active Directory Integration Sample Script
A Microsoft sample script that reads computer names from your SQL Server database and adds them to an Active Directory security group for agent assignment.
SQL SERVER – 2005 – List All The Constraint of Database – Find Primary Key and Foreign Key Constraint in Database
A simple script from my archive lists all constraints from sys.objects, so you can check each foreign key and primary key constraint in database tables.
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.
SQLAuthority News – Random Article from SQLAuthority Blog
I often use the Random Article feature to reread old posts on this blog. Now there is a Random Article link in the sidebar so you can try it too.
SQL SERVER – Difference Between EXEC and EXECUTE vs EXEC() – Use EXEC/EXECUTE for SP always
What is the difference between EXEC and EXECUTE? None. The real difference is EXEC vs EXEC(), and I show why EXEC belongs before every stored procedure call.