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
Dec26

SQLAuthority News – Presented on Database Worst Practices at SQL Live, Orlando – November 29, 2014

Pinal Dave
SQLAuthority News
SQLAuthority Author Visit
No Comments

I presented Database Worst Practices at SQL Live 2014 in Orlando in November. You can read the title and abstract of my demo-oriented session.

Continue Reading
Dec25

SQL SERVER – Performance Tuning – Is It Really A Top Skills for a SQL Server Consultant? – Notes from the Field #059

Pinal Dave
SQL Performance
Notes from the Field, SQL Server Security
No Comments

The world needs more Performance Tuning consultants, but is tuning really the top skill for a SQL Server consultant? Brian Moran answers from a business view.

Continue Reading
Dec24

Page Verify CHECKSUM and Why It Matters

Pinal Dave
SQL Tips and Tricks
Database Corruption, DBA, SQL Backup and Restore, SQL Server DBCC
No Comments

Page verify CHECKSUM detects altered database pages on read; inspect old settings, understand new writes, and review suspect pages.

Continue Reading
Dec24

SQL SERVER – Puzzle – Why Decimal is Rounded Up?

Pinal Dave
SQL Puzzle
SQL Scripts
48 Comments

Why decimal is rounded up in one script and not in the other when both divide 10000 by 17? Try this holiday puzzle before you read the comments.

Continue Reading
Dec23

SQL SERVER – Story of Temporary Objects

Pinal Dave
SQL Tips and Tricks
Devart, SQL Scripts, SQL Server, SQL TempDB
5 Comments

Temp tables, table variables and more: the story of Temporary Objects in SQL Server, why you would use them and how they can help performance and scalability.

Continue Reading
Dec22

SQL SERVER – List the Name of the Months Between Date Ranges – Part 2

Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Scripts, SQL Server
3 Comments

Part 2 on listing the names of the months between date ranges, with an improved script from readers Miladin Joksic and Peter Lalovsky that adds more details.

Continue Reading
Dec21

SQL SERVER – List the Name of the Months Between Date Ranges – Correction

Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function
3 Comments

Sanjay Monpara caught a small error in my script to list the name of the months between two dates: it skipped the first month. Here is his corrected script.

Continue Reading
Previous 1 … 398 399 400 401 402 403 404 … 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