Frequently Asked Questions Day 11: do table and column aliases affect performance, and what is the difference between CHAR and VARCHAR?
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 10 of 31
Frequently Asked Questions Day 10 of my interview series: how to rename a database, a table and a column with sp_renamedb and sp_rename.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 9 of 31
Frequently Asked Questions Day 9 of my SQL Server interview series: CHECK and NOT NULL constraints, and the difference between UNION and UNION ALL.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 8 of 31
Frequently Asked Questions Day 8 shows how to find the SQL Server version and explains what SQL Server Agent does for a DBA, in my interview series.
Incremental Loads: Moving Only What Changed
Design an incremental load with reliable boundaries, retained change information, delete handling, and a watermark that advances only after success.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 7 of 31
Frequently Asked Questions Day 7 explains the different types of locks in SQL Server, like shared, update and exclusive locks, in simple words.
Interview Questions and Answers – Frequently Asked Questions Day 6 of 31
Frequently Asked Questions Day 6: which TCP/IP port SQL Server runs on and how to change it, and the difference between a clustered and a non-clustered index.
SQL Server slow? Let's fix it together in about four hours.
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.

