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
Aug23

Unit of Measure Conversions: One Table for Kilograms, Pounds and Boxes

Pinal Dave
SQL Tips and Tricks
SQL System Table, SQL Table Operation, Table Partitioning, Temp Table
No Comments

Adding kilograms, pounds and boxes gives a number that means nothing. Convert each product to one base unit and find the rows that cannot convert.

Continue Reading
Aug22

SQL SERVER – Scripts to Retrieve Column Names

Pinal Dave
SQL Tips and Tricks
Computed Column, SQL Column, SQL DMV
1 Comment

Understanding how to retrieve column names from a table is one of the fundamental operations you should be familiar with.

Continue Reading
Aug21

SQL SERVER – Transaction Logs: The Good, The Bad, and The Ugly

Pinal Dave
SQL Tips and Tricks
Transaction Log
No Comments

Providing a comprehensive understanding of their role and potential issues. Let us learn about Transaction Logs: The Good, The Bad, and The Ugly.

Continue Reading
Aug18

Webinar – Mastering SQL Query Performance: A Deep Dive into Index Tuning and Analysis

Pinal Dave
SQLAuthority News
Idera, SQL Index, Webinar
No Comments

The webinar topic is Mastering SQL Query Performance: A Deep Dive into Index Tuning and Analysis. I will be hosting this webinar.

Continue Reading
Aug17

SQL SERVER – Unique Indexes on Nullable Columns

Pinal Dave
SQL Tips and Tricks
SQL Index, SQL NULL
No Comments

As the server allows only one null value in a column if a unique constraint is applied. Let us learn about Unique Indexes on Nullable Columns.

Continue Reading
Aug16

The Pigeonhole Principle: Bridging Mathematics and SQL

Pinal Dave
SQL Tips and Tricks
Mathematical Function, SQL Function
No Comments

The other day I was reading Wikipedia, and I ended up on the Pigeonhole Principle. I find it very intriguing about this and I decide to blog

Continue Reading
Aug15

SQL SERVER – Banker’s Rounding

Pinal Dave
SQL Tips and Tricks
Mathematical Function, SQL Function
5 Comments

Also known as unbiased rounding or round half to even, banker’s rounding follows a set of rules that ensures numbers are rounded.

Continue Reading
Previous 1 … 32 33 34 35 36 37 38 … 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