Truncate v Delete

TSQL Lab I - Playing around with ROW_NUMBER

Real world solutions are key and having different techniques can sometimes help you code quicker. Longtime author Jacob Sebastian shows us how to solve a few problems with different techniques.

Trigger Trivia

From SQL Server trainer and guru Andy Warren, he are a few short nuggets that you might not realize about triggers.

OPENROWSET (BULK)

The Baker's Dozen: 13 Productivity Tips for Transact-SQL 2005

SQL Server 2005 offers T-SQL language features that can improve your productivity.

Recompilation Feature

Importing Text-based data: Workbench

Robyn and Phil return with some fresh ideas about how to import text files into SQL Server, without resorting to DTS or SSIS scripting. They go on to show how much can be done in TSQL

Script foreign keys

Using this script you can create a list of sql commands for foreign keys manipulation.

Bit Manipulation Functions (4)

Four bit manipulation functions:
1. Turn bit ON
2. Turn bit OFF
3. Check if bit is ON
4. Toggle bit ON/Off

Aggregating Correlated Sub-Queries

Every now and then you may attempt to calculate an aggregate function -- such as SUM() -- on a correlated subquery, only to encounter the following error: