SQL Server Index Backward Scan: Understanding, Tuning
Table indexing strategy is one of the most important performance tuning and optimization keys. In...
Database Optimization: Indexes
I noticed that very few people understand how indexes work in SQL Server, especially Included Columns. Nevertheless, indexes are the great...
Query Optimization in PostgreSQL. EXPLAIN Basics – Part 2
In my previous article, we started to describe the basics of the EXPLAIN command and analyzed what happens in PostgreSQL when executing a...
Troubleshooting long running queries in MS SQL Server
Preface There is an information system that I administer. The system consists of the following...
SQL Server In-Memory OLTP: The Basics
This is the first article in a series of articles about In-Memory OLTP. It helps you to understand how the new Hekaton engine works...
Retrieving SQL Server Metadata with Help of T-SQL
This article contains a list of scripts that mine the SQL Server metadata in the various system functions, stored procedures, tables, and...
