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
Nov24

SQL SERVER – Interesting Observation – TOP 100 PERCENT and ORDER BY

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

ORDER BY in a view raises Msg 1033 unless TOP is used, so many developers add TOP 100 PERCENT. An interesting observation on what that really does.

Continue Reading
Nov23

SQL SERVER – A Common Design Problem – Should the Primary Key Always be a Clustered Index

Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys
24 Comments

Should the Primary Key always be a clustered index? A design discussion about SSN numbers stored as strings and when a separate clustered index makes sense.

Continue Reading
Nov22

SQL SERVER – Remove Bookmark Key Lookup – 4 Different Ideas

Pinal Dave
SQL Performance
SQL Index
1 Comment

A bookmark key lookup slows down any query. Here are my four posts on removing it, gathered in one place so you can read them in order.

Continue Reading
Nov21

SQL Server for Oracle DBAs: The Vocabulary

Pinal Dave
SQL Tips and Tricks
DBA, Oracle, SQL Server Architecture, Transaction Log
2 Comments

SQL Server for Oracle DBAs translates instance, database, schema, tablespace, undo, and redo without pretending the two architectures are identical.

Continue Reading
Nov20

TDE, Column Encryption and Always Encrypted Compared

Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Server, SQL Server Security
1 Comment

Compare SQL Server encryption options by the threat they address, where keys live, what applications must change, and how recovery is tested.

Continue Reading
Nov19

SQL SERVER – Understanding Table Hints with Examples

Pinal Dave
SQL Performance
SQL Joins, SQL Scripts
13 Comments

What are hints in SQL Server and when should you use them? Understanding table hints with examples, plus a word of caution about overriding the optimizer.

Continue Reading
Nov18

SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table

Pinal Dave
SQL Puzzle
SQL Index, SQL Scripts, SQL Stored Procedure
13 Comments

sp_spaceused shows the total index size of a table. My puzzle for you: write a query that adds the size of each index to the sys.indexes list.

Continue Reading
Previous 1 … 678 679 680 681 682 683 684 … 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