A developer filled a DATETIME and a DATETIME2 column with the same value and got different results. Here is the difference between DATETIME and DATETIME2.
SQL SERVER – Difference Between GETDATE and SYSDATETIME
What is the difference between GETDATE and SYSDATETIME? GETDATE stops at milliseconds, while SYSDATETIME in SQL Server 2008 goes much finer.
SQL SERVER – Fastest Way to Restore Database
A few days ago, I received following email from blog reader where the question was about the fastest way to restore database.
SQL SERVER – MERGE Insert Update and Delete with an Isolated Example
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.