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
Dec6

SQL SERVER – Reverse String Word By Word

Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL String
9 Comments

A reader wanted to reverse string word by word, so “I am Pinal Dave” becomes “Dave Pinal am I”. Here is the function that does it.

Continue Reading
Dec5

SQL SERVER – FIX: Error 5161 – An Unexpected file id was Encountered

Pinal Dave
SQL Tips and Tricks
SQL Error Messages
7 Comments

While building a tempdb demo, SQL Server would not start and ERRORLOG showed Error 5161, an unexpected file id was encountered. I explain what caused it.

Continue Reading
Dec4

SQL SERVER – The Basics of the SSIS Data Flow Task – Notes from the Field #057

Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Backup and Restore, SSIS
No Comments

Andy Leonard explains the basics of the SSIS Data Flow Task and how a novice developer can learn SSIS from the beginning.

Continue Reading
Dec3

SQL SERVER – Beginning with SQL Server Security Aspects

Pinal Dave
SQL Tips and Tricks
Devart, SQL Server Security
1 Comment

A high-level overview of SQL Server security aspects and best practices, starting with the often overlooked physical security of the server itself.

Continue Reading
Dec2

SQL SERVER – How to Disable and Enable All Constraint for Table and Database

Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys
16 Comments

Readers often ask how to disable and enable all constraint for table and database. Here are simple ALTER TABLE scripts for both, plus one for a single constraint.

Continue Reading
Dec1

Hash Index Bucket Count for Memory-Optimized Tables

Pinal Dave
SQL Performance
In-Memory OLTP, SQL Index, SQL Memory, SQL Server
3 Comments

Size hash index bucket count from distinct keys, inspect empty buckets and chains, rebuild a test index, and choose range indexes wisely.

Continue Reading
Nov30

SQL SERVER – Inside Temp table Object Creation – Part II

Pinal Dave
SQL Tips and Tricks
Temp Table
No Comments

A first year developer wrote in with a question after my post on temp table object creation. Here is my answer, with a closer look at tempdb.

Continue Reading
Previous 1 … 401 402 403 404 405 406 407 … 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