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
May9

Windows Path Variable: Run oStress From Any Folder

Pinal Dave
SQL Tips and Tricks
Command Line, SQL Utility, sqlcmd, Windows
1 Comment

The Windows Path variable is a list of folders that Windows searches when you type a program name. This post shows how to test a change in one window, add a folder for good and check that it works. It uses oStress and sqlcmd as the examples and ends with rules for a clean Path.

Continue Reading
May8

Entity-Attribute-Value Tables: Why They Hurt Queries

Pinal Dave
SQL Tips and Tricks
JSON, Normalization, Schema, SPARSE Columns, SQL Server
No Comments

Understand entity-attribute-value query costs, lost types, indexing limits, and alternatives using real columns, sparse columns, or JSON.

Continue Reading
May7

Stress Testing with oStress – SQL in Sixty Seconds #087

Pinal Dave
SQL Video
SQL Download, SQL in Sixty Seconds, SQL Performance, SQL Server, Testing
No Comments

One of the things which we cover in my  Comprehensive Database Performance Health Check is how to do Load Testing or Stress Testing with oStress.

Continue Reading
May6

OPTIMIZE_FOR_SEQUENTIAL_KEY: Test the Last Page Insert Fix

Pinal Dave
SQL Performance
Primary Key, SQL Identity, SQL Server 2019, SQL Wait Stats, Testing
No Comments

OPTIMIZE_FOR_SEQUENTIAL_KEY is an index option that targets last page insert contention. This post tests it with 32 connections that insert into a clustered identity key, with the option off and on. The option changes the kind of waiting, and the post shows how to decide whether it helps your table.

Continue Reading
May5

SQL SERVER – Last Page Insert PAGELATCH_EX Contention Due to Identity Column

Pinal Dave
SQL Performance
Primary Key, SQL Constraint and Keys, SQL Identity, SQL Scripts, SQL Server, SQL Server Management Studio, SQL Wait Stats, Testing
No Comments

Today’s goal is to understand what is the Last Page Insert PAGELATCH_EX Contention Due to Primary Key. Let us start understanding it together.

Continue Reading
May4

Recovery Model Insert Test: FULL vs SIMPLE Under Load

Pinal Dave
SQL Performance
Best Practices, SQL Backup and Restore, SQL Log, SQL Wait Stats, Testing
4 Comments

A recovery model insert test compares FULL and SIMPLE under a load of 16 connections. The log written is almost the same in both, and the elapsed time depends more on the server than on the model. The real difference is when the log can be reused, and this post shows that step by step.

Continue Reading
May3

How to Get Details of All Files Associated with Database from MDF? – Interview Question of the Week #275

Pinal Dave
SQL Interview Questions and Answers
SQL Log, SQL Scripts, SQL Server, SQL Server DBCC
2 Comments

Question: How to Get Details of All files Associated with Database from MDF? Let us learn about the DBCC command DBCC command dbcc checkprimaryfile.

Continue Reading
Previous 1 … 114 115 116 117 118 119 120 … 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