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
Oct12

Extended Security Updates Explained

Pinal Dave
SQL Tips and Tricks
SQL Licensing, SQL Migration, SQL Patch, SQL Server, SQL Server Security
No Comments

Extended Security Updates give eligible older SQL Server releases limited critical security coverage while you complete a migration.

Continue Reading
Oct11

SQL SERVER – Add Auto Incremental Identity Column to Table After Creating Table

Pinal Dave
SQL Tips and Tricks
SQL Identity, SQL Scripts
14 Comments

Can you add an auto incremental identity column to a table after it is created? The answer is both no and yes, and I show the ALTER TABLE script.

Continue Reading
Oct10

SQL SERVER – Row Offset in SQL Server For Different Version

Pinal Dave
SQL Performance
1 Comment

A common question is how to find row offset in SQL Server. I share paging examples for each version, from OFFSET FETCH in 2012 back to SQL Server 2000.

Continue Reading
Oct9

SQL SERVER – ​Tuning Queries is Sometimes Waste of Time – Notes from the Field #049

Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Server Security
1 Comment

Brian Moran explains why tuning queries is sometimes a waste of time when you are trying to fix performance and scalability problems in SQL Server.

Continue Reading
Oct8

SQL SERVER – Reset the Identity SEED After ROLLBACK or ERROR

Pinal Dave
SQL Tips and Tricks
SQL Identity
No Comments

A reader noticed that a failed insert still bumps the identity value. I show how to reset the identity seed after a ROLLBACK or an error.

Continue Reading
Oct7

Finding Hot Tables With sys.dm_db_index_usage_stats

Pinal Dave
SQL Performance
SQL DMV, SQL Index, SQL Lock, SQL Performance, SQL Server
1 Comment

Identify hot tables with index usage, lock and latch counters, table sizes, and retained snapshots that describe a real workload interval.

Continue Reading
Oct6

Default Filegroup: Sending New Tables Away From PRIMARY

Pinal Dave
SQL Tips and Tricks
Database, SQL Data Storage, SQL Server Configuration
No Comments

Changing the default filegroup only affects tables you create later. Here is what moves, what does not, and how a script can quietly ignore the rule.

Continue Reading
Previous 1 … 410 411 412 413 414 415 416 … 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