Performance and Tuning

External Article

Index Scans and Table Scans

  • Article

There are several things that you can do to improve performance by throwing more hardware at the problem, but usually the place you get the most benefit from is when you tune your queries. One common problem that exists is the lack of indexes or incorrect indexes and therefore SQL Server has to process more data to find the records that meet the queries criteria. These issues are known as Index Scans and Table Scans.

2025-06-06

Technical Article

Improve Query Performance when SQL Server Ignores Nonclustered Index

  • Article

Do you wonder why SQL Server ignores an index? Do you think about how you can deal with this problem? When you include too many columns in a query you decrease index selectivity. So, if you write a query like “Select * From …” the chance of choosing your nonclustered index will decrease.

You rated this post out of 5. Change rating

2025-03-03

SQLServerCentral Article

The Paradox of NOLOCK: How Dirty Reads Can Sometimes Be Cleaner

  • Article

Every SQL Server developer has heard it: "Don't use NOLOCK in production!" But this common rule isn't as simple as it seems. Sometimes, what seems like a bad practice can actually be the right choice. Let's explain what NOLOCK really does in simple terms. When you use NOLOCK, you're telling SQL Server "just show me […]

3.89 (9)

You rated this post out of 5. Change rating

2024-12-09

4,946 reads

Blogs

Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests

By

"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...

Adding a Local Model to Ollama through the GUI

By

I saw some good reviews of the small gemma3 model in a few places...

Connect resiliently to SQL Server

By

 Why you should connect resiliently to SQL Server Transient failures happen — in the cloud...

Read the latest Blogs

Forums

using different credentials when debugging ssis

By stan

hi, now and then i want one connection in my ssis pkgs to use...

AlwaysON health check alerts

By Srinivas Merugu

Comments posted to this topic are about the item AlwaysON health check alerts

Bat and SQL script to generate DB user permissions for all Databases in SQL server

By Srinivas Merugu

Comments posted to this topic are about the item Bat and SQL script to...

Visit the forum

Question of the Day

PWDCompare

What does the PWDCOMPARE function do?

See possible answers