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
Oct8

go-sqlcmd: The New Command Line Tool for SQL Server

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

Set up go-sqlcmd on Windows, verify the executable, run scripts and variables, control output, and review optional container commands.

Continue Reading
Oct7

SCHEMABINDING View: What You Can Change in the Table

Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Table Operation, SQL View
No Comments

A SCHEMABINDING view locks the columns it uses and leaves the other columns of the table free. This post tests which changes SQL Server blocks, shows the messages and lists the bound columns with a query. It also shows how to change a bound column inside one transaction.

Continue Reading
Oct6

What is SCHEMABINDING in SQL Server Views? – Interview Question of the Week #245

Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server, SQL Table Operation, SQL View
3 Comments

SCHEMABINDING keywords prevent tables used in the views to make any such modifications that can affect the view’s definition. 

Continue Reading
Oct5

RSFXDEVICEOPS Wait: Unneeded WAITFOR DELAY Slowing Queries

Pinal Dave
SQL Performance
Comprehensive Database Performance Health Check, Filestream, SQL Server, SQL Wait Stats
1 Comment

The RSFXDEVICEOPS wait, listed as PREEMPTIVE_OS_RSFXDEVICEOPS, was high at a client that did not use FileStream. Their queries carried a WAITFOR DELAY nobody remembered adding. When the clause came out, the wait dropped and the queries got fast again.

Continue Reading
Oct4

Memory-Optimized Files: List Logical and Physical Names

Pinal Dave
SQL Performance
In-Memory OLTP, SQL DMV, SQL Memory, SQL Scripts
No Comments

To list memory-optimized files, join sys.dm_db_xtp_checkpoint_files to sys.database_files. This post builds a small memory-optimized database, shows the container’s logical and physical name and counts its checkpoint files by type and state. It also explains why a container holds far more disk space than its data uses.

Continue Reading
Oct3

AVG of an Integer Column Returns an Integer: Getting Decimals Back

Pinal Dave
SQL Tips and Tricks
Computed Column, SQL Column, SQL Server
No Comments

The dashboard says the average is 1 when everyone can see it is 1.5. Here is why AVG does that and the one-line fix.

Continue Reading
Oct2

Drop Multiple Columns in One ALTER TABLE Statement

Pinal Dave
SQL Tips and Tricks
SQL Column, SQL Scripts, SQL Table Operation
No Comments

To drop multiple columns, list them after one DROP COLUMN in one ALTER TABLE statement. This post tests the syntax on a table with a default, a check constraint and an index, shows the error that a dependent object causes and drops the constraints and columns together. It also explains why the disk space doesn’t return until a rebuild.

Continue Reading
Previous 1 … 145 146 147 148 149 150 151 … 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