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
Jan13

DACPAC vs BACPAC Quiz: Which File Carries Your Data?

Pinal Dave
SQL Puzzle
Cloud Computing, Schema, SQL Backup and Restore, SQL Migration
1 Comment

This DACPAC vs BACPAC Quiz asks which file moves a database with its rows to Azure SQL Database. The answer is the BACPAC. A tested script shows what each file describes, and the SqlPackage commands show how to use them.

Continue Reading
Jan12

Nonclustered Index Rebuild Quiz: Does a Clustered Rebuild Touch Them?

Pinal Dave
SQL Puzzle
Clustered Index, SQL Heap, SQL Index, SQL Statistics
4 Comments

This Nonclustered Index Rebuild Quiz asks what happens to the other indexes when you rebuild the clustered index. The answer is nothing, and a tested script shows it. It also covers the cases where SQL Server does rebuild them.

Continue Reading
Jan11

Data Quality Rules in T-SQL

Pinal Dave
SQL Tips and Tricks
Data Observability, ETL, SQL Constraint and Keys, SQL Server
No Comments

Data quality rules in T-SQL turn nulls, duplicates, invalid dates, and broken references into visible failures before rows reach reports.

Continue Reading
Jan11

OUTPUT Clause Quiz: What Do inserted and deleted Hold?

Pinal Dave
SQL Puzzle
Output Clause, SQL Delete, SQL Table Operation, SQL Transactions
2 Comments

This OUTPUT Clause Quiz raises a price from 10 to 12 and asks which two values come back. The answer is 10 and 12, because deleted holds the old row and inserted the new one. A tested script proves it and shows OUTPUT with INSERT, DELETE and an audit table.

Continue Reading
Jan10

Blocking and Deadlock Quiz: Which One Ends by Itself?

Pinal Dave
SQL Puzzle
Deadlock, SQL Error Messages, SQL Lock, SQL Transactions
1 Comment

This Blocking and Deadlock Quiz asks which problem SQL Server ends on its own, and how the losing session finds out. A two-window test on SQL Server 2025 shows the deadlock error 1205 and the lock timeout error 1222. It also shows how to find a blocker and how to retry.

Continue Reading
Jan9

Ranking Functions Quiz: ROW_NUMBER, RANK or DENSE_RANK?

Pinal Dave
SQL Puzzle
Ranking Functions, SQL Cursor, SQL Function, SQL Order By
1 Comment

This Ranking Functions Quiz uses two tied scores to ask what number the next student gets from ROW_NUMBER, RANK and DENSE_RANK. The answer is 3, 3 and 2. A tested script proves it and replaces a cursor loop with one query.

Continue Reading
Jan8

Indexed View Restrictions Quiz: Which Rule Blocks the Index?

Pinal Dave
SQL Puzzle
Clustered Index, SQL Error Messages, SQL Index, SQL Joins, SQL View
1 Comment

This Indexed View Restrictions Quiz asks which rule stops a unique clustered index on a view. The answer is the LEFT OUTER JOIN. A tested script shows the error, the working view, and what happens when each required rule is missing.

Continue Reading
Previous 1 … 558 559 560 561 562 563 564 … 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