This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Aug26

SQL SERVER – Adding Column is Expensive by Joining Table Outside View – Limitation of the Views Part 2

Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL View
10 Comments

Need one more column from a view? Joining table outside view is expensive, and changing the view adds network traffic for every query. Views limitation part 2.

Continue Reading
Aug25

SQL SERVER – Does Order of Column in WHERE Clause Matter?

Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server
21 Comments

Does the Order of Column in WHERE Clause change a query plan? I invite a runnable example with a controlled comparison.

Continue Reading
Aug24

Assessing a Database Before a Migration

Pinal Dave
SQL Tips and Tricks
Compatibility Level, DBA, Query Store, SQL Migration
1 Comment

Assessing a database before a migration covers features in use, compatibility, size, dependencies, and the evidence needed before a date is promised.

Continue Reading
Aug24

Spatial Indexes: Speeding Up Distance Searches

Pinal Dave
SQL Performance
Execution Plan, Spatial Database, SQL Index, SQL Server
No Comments

Use spatial indexes for geography distance searches, compare actual plans and reads, and inspect tessellation with built-in diagnostics.

Continue Reading
Aug23

SQL SERVER – ORDER BY Does Not Work – Limitation of the Views Part 1

Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL View
64 Comments

Why ORDER BY does not work in a view: the first limitation of views in my series, shown with an AdventureWorks example. Sort outside the view instead.

Continue Reading
Aug22

SQL SERVER – Computed Columns – Index and Performance

Pinal Dave
SQL Performance
SQL Index, SQL Scripts
7 Comments

The last article in my series on computed columns looks at index and performance, with a summary of every earlier part on storage and PERSISTED columns.

Continue Reading
Aug21

SQL SERVER – Computed Column – PERSISTED and Storage – Part 2

Pinal Dave
SQL Performance
SQL Data Storage, SQL Scripts
4 Comments

Part 2 of my look at the computed column and its effect on storage, with a list of the earlier articles in the series on PERSISTED storage and performance.

Continue Reading
Previous 1 … 637 638 639 640 641 642 643 … 846 Next

SQL Server slow? Let's fix it together in about four hours.

Pinal Dave

In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.

You keep every script, and the know-how to fix it yourself next time.

Want your whole team to learn it?

My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.

Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.


Who We Are

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 19 books and 125 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).


Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.


Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com