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
Mar15

SQL SERVER – The Need for Data Tier Elasticity in Cloud Computing

Pinal Dave
SQL Tips and Tricks
Cloud Computing, SQL Server
No Comments

Workloads rise and fall, yet on-premises capacity is sized for the worst day. Here is why data tier elasticity in cloud computing matters.

Continue Reading
Mar14

OPENJSON WITH Clause: Converting JSON Properties to Typed Values

Pinal Dave
SQL Tips and Tricks
JSON, Output Clause, SQL Union clause
No Comments

Without WITH, OPENJSON hands you text. With it, you pick the names and types and decide what happens when a property is missing.

Continue Reading
Mar13

Interview Question of the Week #062 – How to Find Table Without Clustered Index (Heap)?

Pinal Dave
SQL Interview Questions and Answers
Clustered Index, SQL Constraint and Keys, SQL Scripts, SQL Server
1 Comment

Not every table has a clustered index. Here is a quick script to find each table without a clustered index, also called a Heap, in your database.

Continue Reading
Mar12

SQL SERVER – Installation Error – File Format is Not Valid

Pinal Dave
SQL Tips and Tricks
File format, SQL Error Messages, SQL Server
9 Comments

At the license agreement step, SQL Server setup stopped with ‘File format is not valid’. Here is what caused this Installation Error for my client and the fix.

Continue Reading
Mar11

Comparison – Understanding Tables Between Oracle and SQL Server

Pinal Dave
SQL Tips and Tricks
Oracle, SQL Server
12 Comments

Oracle and SQL Server table names can hide important differences. Compare storage, temporary-row visibility, external data and memory-focused features.

Continue Reading
Mar10

SQL SERVER – The NOLOCK Question – Notes from the Field #117

Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Server, SQL Server Security, SQL Statistics
4 Comments

Stuart Ainsworth discusses NOLOCK, dirty reads and safer alternatives. A two-session example shows why uncommitted results can be misleading.

Continue Reading
Mar9

Generating Test Data That Behaves Like the Real Thing

Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server
No Comments

Make test data generation reflect skew, row width, missing values, and key relationships so your SQL Server experiments expose realistic plan risks.

Continue Reading
Previous 1 … 333 334 335 336 337 338 339 … 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