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
Sep28

What Is a Data Type, and Why the Wrong One Costs You

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

A data type decides what a column holds, what it costs in bytes, and how SQL Server compares it. Why NVARCHAR doubles your storage, why float will not compare cleanly, and the conversion that quietly kills an index.

Continue Reading
Sep27

SQL SERVER – Extension of the SQL Server Natively Compiled Stored Procedures

Pinal Dave
SQL Tips and Tricks
In-Memory OLTP, SQL Server
No Comments

What are the .c, .dll, .obj and .pdb files created for Natively Compiled Stored Procedures in SQL Server 2014? A quick list of each extension and what it does.

Continue Reading
Sep26

SQL SERVER – Performance Dashboard – Historic Information

Pinal Dave
SQL Performance
SQL Reports
2 Comments

Travels with my daughter taught me the value of history. The Historic Information section of Performance Dashboard does the same for your SQL Server.

Continue Reading
Sep25

SQL SERVER – Database Taking Long Time to Create – Notes from the Field #047

Pinal Dave
SQL Performance
Notes from the Field
1 Comment

Ever seen a database taking a long time to create? Tim Radney explains in simple words why it happens, based on a real question from a forum.

Continue Reading
Sep24

Current Activity Section: Performance Dashboard Reports Explained

Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Monitoring, SQL Reports, SQL Server
1 Comment

The Current Activity section of Performance Dashboard shows what is running right now, split into user requests and user sessions, taken from two DMVs.

Continue Reading
Sep23

SQL SERVER – SSMS: Performance Dashboard Reports – Home Page details

Pinal Dave
SQL Tips and Tricks
SQL Reports
7 Comments

Here are the Performance Dashboard home page details: lots of server information in one view. I walk through its six sections one after another.

Continue Reading
Sep22

SQL SERVER – SSMS: Performance Dashboard Installation and Configuration

Pinal Dave
SQL Tips and Tricks
SQL Reports
8 Comments

Performance Dashboard reports are free custom reports from the Microsoft SQL Server Support team. Here is the Performance Dashboard installation and setup in SSMS.

Continue Reading
Previous 1 … 412 413 414 415 416 417 418 … 847 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