At first, let’s start with a cool relaxation exercise. Close your eyes and imagine that your DBA work environment includes only one...

Microsoft SQL Server Reporting Services is an excellent and easy-to-use platform for creating, viewing, managing, and subscribing to...

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