SQL Shack

JANUARY 16, 2020

This article gives an introduction of the non-clustered index in SQL Server using examples. Introduction In a previous article Overview of SQL Server Clustered indexes, we explored the requirement of an index and clustered indexes in SQL Server.

Servers 58

Servers Performance 58

SQL Shack

DECEMBER 23, 2019

This article targets the beginners and gives an introduction of the clustered index in SQL Server. Introduction An index plays a crucial role in SQL Server query performance. Consider a book library with thousands of books. The books in […].

Servers 58

Servers Performance 58

Percona

DECEMBER 14, 2022

Indexes are not feasible . Creating EXPRESSION indexes on columnar tables is faster by orders of magnitude than on heap tables. This blog is the result of my investigation into column-wise tables. Hopefully, you will find it useful in your deliberations. When I started writing it was meant to be a “Good News” blurb. Column-wise tables!

Database 92

Database Analytics Storage Processing 92

Percona

JUNE 4, 2023

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

SQL Performance

NOVEMBER 4, 2021

First introduced in SQL Server 2017 Enterprise Edition, an adaptive join enables a runtime transition from a batch mode hash join to a row mode correlated nested loops indexed join (apply) at runtime. For brevity, I’ll refer to a “correlated nested loops indexed join” as an apply throughout the rest of this article.

Servers 98

Servers Design Database Code 98

Percona

JULY 1, 2023

In this blog, we will answer all of these important questions and provide a general overview comparing the two database services, Aurora vs RDS. What are the differences between Aurora and RDS? How do I choose which one to use?

AWS 52

AWS Database Serverless Storage 52

SQL Server According to Bob

JANUARY 11, 2020

Copyright The information ​​ that is contained ​​ in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. This White Paper is for informational purposes only.

Servers 40

Servers Cache Database Media 40