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
Jun18

SQL SERVER – Clustered Index on Separate Drive From Table Location

Pinal Dave
SQL Performance
Best Practices, SQL Constraint and Keys, SQL Index, SQL Server
11 Comments

A Jr. developer asked if a clustered index can live on a separate Drive from its table. The answer is no, and the clustered vs non clustered difference shows why.

Continue Reading
Jun17

SQL SERVER – List Schema Name and Table Name for Database

Pinal Dave
SQL Tips and Tricks
SQL Scripts
32 Comments

A quick query on sys.tables with SCHEMA_NAME() that lists the schema name and table name of every table in a database, in bracketed form.

Continue Reading
Jun16

SQLAuthority News – 1000th Article Milestone – 8 Millions Views – Solid Quality Mentors

Pinal Dave
SQLAuthority News
MVP, SQL User Group
10 Comments

Today I write my 1000th article on this blog, with 8 million views so far. Thank you to every reader who made this long journey so rewarding.

Continue Reading
Jun15

SQL SERVER – Query Optimizer Hint ROBUST PLAN – Question to You

Pinal Dave
SQL Performance
Query Hint, SQL Scripts
3 Comments

What does the query optimizer hint ROBUST PLAN do? I explain query hints in simple words and ask you for a practical example of ROBUST PLAN in action.

Continue Reading
Jun14

SQL SERVER – 2008 – SSMS Feature – Multi-server Queries

Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server Management Studio
8 Comments

SSMS 2008 lets DBAs run one query against many servers from one window. Here is how multi-server queries work, a tip from my TechEd India session.

Continue Reading
Jun13

SQL SERVER – Effect of Normalization on Index and Performance

Pinal Dave
SQL Tips and Tricks
Normalization, SQL Index, SQL Server
7 Comments

Normalization organizes data dependencies, while indexes support access paths. I evaluate their performance effects through the actual workload.

Continue Reading
Jun12

SQL SERVER – 2008 – Customize Toolbar – Remove Debug Button from Toolbar

Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Server Management Studio
3 Comments

SQL Server 2008 brought the debugger back, and its button sits right next to Execute. Here is how to customize toolbar buttons and remove the debug button.

Continue Reading
Previous 1 … 701 702 703 704 705 706 707 … 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