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

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