Articles

Indexes: When Column Selectivity Is Not Always A Requirement

While preparing for my SQL Saturday Salt Lake City presentation, Climbing the B-Tree, I ran into one of the “word of mouth” facts that the first column of an index should be highly selective, i.e., it should only point to one or a few rows. This is not always the case and I’ll show you […]

5 (1)

2020-09-16

1,807 reads

Free eBook: Defensive Database Programming

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.

2020-09-16 (first published: )

105,836 reads

Power BI Histogram Example using DAX

Companies use a Bell Curve approach to measure performance. As part of this approach they create a histogram. A histogram is a statistical concept and according to Wikipedia it is defined as a graphical distribution of the numerical data. A histogram is made of several bins and bins can be considered a range of values or a benchmark

2020-09-16

Blogs

Daily Coping 18 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Optimize for Unknown for Inline Table-Valued Functions

By

I had a curious performance issue today. An inline table-valued function (iTVF) was performing...

Daily Coping 17 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

will this get replicated to secondary replica

By coolchaitu

Dear Experts, In Availability Group, if we move ndf file to another drive on...

slow query performance

By vsamantha35

Hi All, I have a SELECT query which is taking more 8 mins. Can...

How Many Rows Remain?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How Many Rows Remain?

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers