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
Dec29

SQL SERVER – Get Date of All Weekdays or Weekends of the Year

Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts
28 Comments

Tejas Shah’s easy script to list the date of all weekdays or weekends of a year with a recursive CTE, first written to find every Sunday of 2010.

Continue Reading
Dec28

SQL SERVER – Difference Temp Table and Table Variable – Effect of Transaction

Pinal Dave
SQL Performance
Best Practices, Database, SQL Scripts, SQL Transactions
34 Comments

Temp table versus table variable, part two: a transaction rollback undoes changes to a temp table, but a table variable keeps its values.

Continue Reading
Dec27

Which Features You Lose When You Drop an Edition

Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Server, SQL Server Installation
25 Comments

Review SQL Server edition features before moving down an edition, check persisted dependencies, and test maintenance and availability behavior.

Continue Reading
Dec26

DATETIME2FROMPARTS: Match Fractions to Precision

Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Server
No Comments

DATETIME2FROMPARTS constructs a complete typed timestamp. Match fraction units to precision and preserve valid calendar components.

Continue Reading
Dec25

SQL SERVER – CDC and TRUNCATE – Cannot truncate table because it is published for replication or enabled for Change Data Capture

Pinal Dave
SQL Tips and Tricks
Change Data Capture, SQL Error Messages, SQL Scripts, SQLAuthority Author Visit
16 Comments

Does CDC capture a TRUNCATE? No. On a table enabled for Change Data Capture you get Msg 4711: Cannot truncate table. I recreate the error step by step.

Continue Reading
Dec24

Prefix Searches: LIKE, LEFT and CHARINDEX

Pinal Dave
SQL Performance
SQL Index, SQL Performance, SQL Scripts, SQL Server
No Comments

LIKE, LEFT and CHARINDEX can match the same prefix through different access paths. Compare complete matching rows and measured plans, then test literal wildcard characters and collation before choosing a search expression.

Continue Reading
Dec23

SQL SERVER – ORDER BY Clause and TOP WITH TIES

Pinal Dave
SQL Tips and Tricks
SQL Scripts
24 Comments

How does TOP WITH TIES work with ORDER BY? A simple example shows how WITH TIES returns the extra rows that match the value of the last row.

Continue Reading
Previous 1 … 673 674 675 676 677 678 679 … 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