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
May19

Indexing Foreign Keys

Pinal Dave
SQL Performance
SQL Constraint and Keys, SQL Index, SQL Lock, SQL Server
2 Comments

Indexing foreign keys can speed joins and parent deletes when child-side indexes are missing; learn how to find gaps and test write tradeoffs.

Continue Reading
May18

What a DBA Actually Does All Day

Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server
5 Comments

Understand what a DBA does across incidents, prevention, projects, and automation, with practical checks that connect daily work to business risk.

Continue Reading
May17

What Is Compatibility Level in SQL Server?

Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Performance, SQL Server
4 Comments

Compatibility level in SQL Server is a per-database setting, and upgrading the server does not change it. Why a restored database keeps the old level, what the setting really controls, and how to raise it without breaking a report.

Continue Reading
May16

Sizing a New SQL Server

Pinal Dave
SQL Tips and Tricks
DBA, Hardware, SQL CPU, SQL Memory
No Comments

Sizing a new SQL Server starts with workload evidence, growth, and recovery goals to estimate CPU, memory, storage, and headroom.

Continue Reading
May15

SQL SERVER – List All the DMV and DMF on Server

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

“How many DMV and DVF are there in SQL Server 2008?” – this question was asked to me in one of the recent SQL Server Training.

Continue Reading
May14

SQL SERVER – Finding Expensive Cached Query Statements with DMVs

Pinal Dave
SQL Performance
SQL DMV, SQL Scripts, SQL Server
56 Comments

Finding the Most Expensive Queries starts with choosing a resource measure. I use cached statistics as an investigation aid.

Continue Reading
May13

XML nodes: Turn Repeated Elements Into Rows

Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts
No Comments

XML nodes maps elements to rows. Extract values relative to each node, preserve duplicates, and review documents without matching children.

Continue Reading
Previous 1 … 652 653 654 655 656 657 658 … 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