what-is-the-difference-between-clustered-and-non-clustered-indexes-in-sql-server 
SQL Performance
MAY 7, 2020
The tipping point is a term I first heard used by SQL Server performance tuning guru and long-time SentryOne Advisory Board member Kimberly Tripp – she has a great blog series on it here. The basic formula is: A clustered index (or table) scan will occur when estimated rows exceeds 33% of the number of pages in the table.
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?
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
SQL Performance
DECEMBER 11, 2019
NULL handling is one of the trickier aspects of data modeling and data manipulation with SQL. Let's start with the fact that an attempt to explain exactly what a NULL is is not trivial in and of itself. I start with coverage of what NULLs are and how they behave in comparisons. Let's start with understanding what NULLs are.
SQL Performance
JANUARY 13, 2021
Finally, the outer query computes the numbers in the requested range between the inputs @low and @high. Finally, the outer query computes the numbers in the requested range between the inputs @low and @high. The dbo.GetNumsItzikBatch function uses a dummy join to a table with a columnstore index to get batch processing.
SQL Performance
MARCH 11, 2020
In the previous articles ( Part 1 , Part 2 , and Part 3 ), I covered the meaning of the NULL as a marker for a missing value, how NULLs behave in comparisons and in other query elements, and standard NULL handling features that are not yet available in T-SQL. Nonfiltered unique index. Standard UNIQUE constraint. Unique constraint.
Percona
DECEMBER 14, 2022
It references the sound that one hears when cooking certain delicious foods i.e. bacon or fajitas and therefore transfers those feelings to non-edible objects or ideas. What is this sizzling feature that I speak of you ask? OLAP is a major component of overall activity i.e. lots of different kinds of SELECT statements.
SQL Performance
AUGUST 19, 2020
Why this isn't a metadata-only operation in modern versions of SQL Server is beyond me, but that's another post.). Usually when we deal with this issue, they are wide and massive tables (in both row count and sheer size), and the column we need to change is the only/leading column in the clustering key. But I'm lazy!
Expert insights. Personalized for you.
69 
Let's personalize your content