SQL Index Archives - SQL Authority with Pinal Dave

SQL SERVER – Aligned and Non-Aligned Indexes for Partitioning

November 8, 2023

In the context of partitioning, it’s essential to understand the concepts of aligned and non-aligned indexes. Let us learn about it today.

October 26, 2023

Let us learn to compare LIKE vs LEFT for Column Comparisons. When writing SQL queries, developers have a myriad of options.

October 23, 2023

Few even asked me to build a video on this topic. Hence, I decided to make a Function in the WHERE Clause – SQL in Sixty Seconds 201.

October 17, 2023

I recently talked about Ins and Outs of Online Index Operations with my clients during the Comprehensive Database Performance Health Check.

October 9, 2023

This blog post aims to shed light on the performance impact between questions that use functions within the WHERE clause.

October 6, 2023

This comprehensive guide explore into some essential maintenance techniques and best practices to ensure your SQL Server deployment.

October 4, 2023

Let us learn The Intricacies of T-SQL String Comparison. In SQL, the way you compare strings can greatly impact the results of your queries.