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
Feb7

ISO Week Numbers: Find the Matching ISO Week Year

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

ISO week numbers can belong to a different year from the calendar date. A Thursday-based calculation keeps the ISO year and week together across December and January.

Continue Reading
Feb6

CDC Capture Lag: Read sys.dm_cdc_log_scan_sessions

Pinal Dave
SQL Tips and Tricks
Change Data Capture, SQL Monitoring, SQL Server, Transaction Log
No Comments

CDC capture lag measures work committed at the source that the capture process has not yet exposed. Compare known markers, scan sessions and captured LSNs, and distinguish capture progress from a downstream consumer reading the changes.

Continue Reading
Feb5

SQL SERVER – Stream Aggregate Showplan Operator – Reason of Compute Scalar before Stream Aggregate

Pinal Dave
SQL Tips and Tricks
SQL Scripts
9 Comments

Stream Aggregate is a common showplan operator, even in a simple COUNT(*) plan. I explain why a Compute Scalar often shows up right before it.

Continue Reading
Feb4

SQL SERVER – Get the List of Object Dependencies – sp_depends and information_schema.routines

Pinal Dave
SQL Tips and Tricks
SQL Dependency, SQL Scripts, SQL Server, SQL Server Security, SQL System Table
49 Comments

sp_depends can return wrong dependency results where information_schema.routines gets it right. See where it fails and the DMVs recommended in its place.

Continue Reading
Feb3

SQLAuthority News – MVP Open Day South Asia – Jan 20, 2010 – Jan 23, 2010 – Review Part Fun

Pinal Dave
SQLAuthority News
MVP, SQL User Group, SQLAuthority Author Visit
13 Comments

MVP Open Day South Asia at Microsoft IDC Hyderabad was fun and educational. I met fellow MVPs and product group experts, and my family came along too.

Continue Reading
Feb2

SQLAuthority News – MVP Open Day South Asia – Jan 20, 2010 – Jan 23, 2010 – Review Part Business

Pinal Dave
SQLAuthority News
MVP, SQL User Group, SQLAuthority Author Visit
2 Comments

MVP Open Day South Asia 2010 at Microsoft IDC Hyderabad was fun and educational: meeting product team members, old friends and experts from across the region.

Continue Reading
Feb1

SQL SERVER – Question – How to Convert Hex to Decimal

Pinal Dave
SQL Puzzle
25 Comments

An inline function converting Hex to Decimal was slowing a client query. I tuned it, and now I ask readers to share the scripts they use for this.

Continue Reading
Previous 1 … 667 668 669 670 671 672 673 … 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