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
Aug11

SPID, KPID and ECID in sys.sysprocesses: What They Mean

Pinal Dave
SQL Tips and Tricks
Parallel, SQL DMV, SQL Scripts, System Object
4 Comments

SPID, KPID and ECID are the three ID columns of sys.sysprocesses: the session, the Windows thread and the part of a parallel query. This post reads them for an idle session and for a query running in parallel, explains why KPID can be negative, and names the DMVs that give the same answers today.

Continue Reading
Aug10

SQL SERVER – Database Scoped Configurations – Query Optimizer Fixes

Pinal Dave
SQL Performance
SQL Server Configuration, SQL Server Management Studio, TraceFlags
7 Comments

During recent SQL Server Performance Tuning Practical Workshop I receive following question about Query Optimizer Fixes.

Continue Reading
Aug9

SQL Download – SQL Server Management Studio (SSMS) – Performance Dashboard

Pinal Dave
SQL Performance
SQL Download, SQL Reports, SQL Server Management Studio
9 Comments

The latest SQL Server Management Studio now includes the Performance Dashboard by default. Here is the free SSMS download link and a quick look at it.

Continue Reading
Aug8

SQL SERVER – How to Build Three Part Name from Object_ID – Part 2?

Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server, System Object
4 Comments

Rin Sitah replied to my interview question with a neat alternative way to build three part name from Object_ID using sys.objects and sys.schemas.

Continue Reading
Aug7

SQL SERVER – How to Convert CollationID to Collation Name?

Pinal Dave
SQL Tips and Tricks
SQL Collation, SQL Scripts, SQL Server
No Comments

A reader with only MDF files and no backups got a CollationID from DBCC CHECKPRIMARYFILE. Here is how to convert that CollationID to a Collation Name.

Continue Reading
Aug6

How to Build Three Part Name from Object_ID? – Interview Question of the Week #134

Pinal Dave
SQL Interview Questions and Answers
SQL Function, SQL Scripts, SQL Server, System Object
6 Comments

If you only have an object_id, can you get the database, schema and object name? Here is a simple script that builds the Three Part Name from Object_ID.

Continue Reading
Aug5

SQL SERVER – FIX: The Log for Database Cannot be Shrunk Until All Secondaries Have Moved Past the Point Where the Log was Added

Pinal Dave
SQL Tips and Tricks
AlwaysOn, Shrinking Database, SQL Error Messages, SQL Replication, SQL Server, Transaction Log
2 Comments

Shrinking a bloated AlwaysOn log gave me: the log cannot be shrunk until All Secondaries have moved past the point where the log was added. Here is the fix.

Continue Reading
Previous 1 … 258 259 260 261 262 263 264 … 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