Today I want to talk about Log Shipping. Log Shipping is an easy way to implement a high availability solution. It uses SQL Server’s...

After my last post about monitoring deadlocks, I will now show a way to prevent deadlocks and unnecessary locks and to improve system...

What comes first, the chicken or the egg? What happens first – update statistics or re-compilations? The Statistics life cycle As a...

Today I chose to talk about Virtual Log Files or VLF in short. VLFs are the physical files that implement the log file. The log file’s...

In order to monitor and analyze deadlocks in your server you will first need to understand what does deadlock mean.  The Books Online...

Sometimes we want to populate a table with random data, mainly for testing purposes. For example, let’s consider the following table:...

As I’ve mentioned in my previous post, there is a catch when using a table variable as a part of a transaction. It behaves differently...

Today I’ll talk about the available JOIN operator types in SQL Server (Nested Loops, Hash and Merge Joins), their differences, best...

Look at the following 3 scripts: Transact-SQL -- 1. Hardcoded SELECT * FROM Sales.Orders WHERE DateAndTime < '19900101' -- 2. Variable...

A lot of times, when creating a procedure, we need to use some kind of an empty table in order to perform all kinds of calculations. The...