Merge Operations can combine conditional inserts, updates and deletes. I inspect the plan before making any claim about scans or speed.
SQL SERVER – Subquery or Join – Various Options – SQL Server Engine Knows the Best – Part 2
In part 2, Paulo R. Pereira compares IN, EXISTS, SOME and JOIN plans, and shows again that the SQL Server Engine knows the best plan for a query.
SQL SERVER – Subquery or Join – Various Options – SQL Server Engine knows the Best
Subquery or join, IN or EXISTS? Four queries return the same result, and the execution plans show the SQL Server engine knows the best way to run them.
SQL SERVER – Convert IN to EXISTS – Performance Talk
A training attendee asked for a simple way to convert IN to EXISTS for better performance. Here is my example with the execution plans.
SQL SERVER – Generate Database Script for SQL Azure
Scripts from a regular SQL Server database used to fail on SQL Azure. With SQL Server 2008 R2 you can generate a database script for SQL Azure. Here is how.
SQL SERVER – Stored Procedure and Transactions
Is a stored procedure transactional by itself? No. A simple example with three tables shows why stored procedure and transactions are separate things.
SQL SERVER – Precision of SMALLDATETIME – A 1 Minute Precision
The precision of SMALLDATETIME is 1 minute. Seconds are rounded up or down to the nearest minute, and this simple example shows exactly how.







