SQL Server Resumable Index: Is it good for you?

07:02 Database development, Indexes

SQL 2017 introduced the ability to pause and resume index rebuild operations during database...
Read More

A Simple Use Case for Indexes on Primary Keys

17:13 Database administation, Database development, Indexes, Perfomance Tuning, SQL Server • 3 Comments

Introduction Recently we encountered an interesting performance problem on one of our SQL Server databases that process transactions at a...
Read More

Hash What? Understanding Hash Indexes

11:40 Database development, Indexes

Hash indexes are an integral part of databases. If you’ve ever used a database, chances are that you have seen them in action without...
Read More

Easy Answers to 5 Vital Questions about Composite Index in SQL

10:53 Database development, Indexes

Imagine you need to query a table with a WHERE clause on columns a, b, and c. Sometimes, you filter...
Read More

Clustered and Non Clustered Index: 7 Top Points Explained

12:46 Database development, Indexes • One Comment

Indexes are speed-boosters in SQL databases. They can be clustered or non-clustered. But what does it mean and where should you apply...
Read More

3 Methods to Rebuild All Indexes for All Tables with T-SQL in SQL Server Database

12:36 Database development, Indexes, Languages & Coding, T-SQL, Tables

There are several methods of how to rebuild all indexes of all tables in SQL Server, among them: Using SQL Server maintenance plans. Using...
Read More

Renaming Indexes with sp_rename Procedure

12:56 Database development, Indexes, Stored Procedures

Not so long ago, I was working on a project where we needed to change the data type of a table. The...
Read More

Virtual Columns and Functional Indexes

12:06 Database development, Indexes, Tables

Much too often, we see poorly written complex SQL queries running against the database tables. Such queries may take a very short or a very...
Read More

SQL Server Indexes Management Using Index Manager for SQL Server

18:01 Database development, Indexes, Tools & technologies, Utilities & Extensions

SQL Server Index Overview When talking about SQL Server performance tuning and queries enhancement, the first thing to consider is the SQL...
Read More

Query Store: Showing the Impact of Indexes on Inserts

14:54 Database development, Indexes

Introduction It is common knowledge in database circles that indexes improve query performance...
Read More