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...

A few weeks ago Kalen Delaney presented a 3-day seminar in Israel. Unfortunately, I wasn’t able to attend the seminar, but some of our...

Three months ago, I presented a session at the special Rosh HaShana user group meeting. The session was about Monitoring Page Splits. I...

This script creates the “PrintMax” stored procedure, which prints a text of any size. It’s intended to replace the “Print” statement,...

Recently I’ve stumbled upon an apparently little known fact about SQL Server – specifically SQL Server collations and how they affect...