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
Aug8

Protecting an Instance You Cannot Patch Any More

Pinal Dave
SQL Tips and Tricks
SQL Migration, SQL Patch, SQL Server, SQL Server Security, SQL Upgrade
1 Comment

Protect an Instance You Cannot Patch with isolation, least privilege, disabled features, tested backups, and a firm retirement date.

Continue Reading
Aug8

Hierarchyid Subtree: Move With GetReparentedValue

Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Datatype, SQL Server, SQL Transactions
No Comments

Move a hierarchyid subtree while keeping stable node identifiers. Check the whole branch, repeated requests, missing endpoints and cyclic destinations.

Continue Reading
Aug7

SQL SERVER – EXCEPT Clause in SQL Server is Similar to MINUS Clause in Oracle

Pinal Dave
SQL Performance
SQL Joins, SQL Scripts
54 Comments

Is there a MINUS clause in SQL Server like in Oracle? Yes, EXCEPT returns the rows of the first query that are not in the second. Example included.

Continue Reading
Aug6

SQL SERVER – Query to Find Column From All Tables of Database

Pinal Dave
SQL Tips and Tricks
SQL Data Storage, SQL Scripts, SQL Stored Procedure, SQL System Table
191 Comments

How many AdventureWorks tables have an EmployeeID column? My query on sys.tables and sys.columns finds any column from all tables, with schema names.

Continue Reading
Aug5

SQL SERVER – 2005 – Get Field Name and Type of Database Table

Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL System Table
80 Comments

How do you get the field name and type of a table in SQL Server 2005? Imran Mohammed answers with sp_help and an INFORMATION_SCHEMA.COLUMNS query.

Continue Reading
Aug4

Who Changed a Server Setting in SQL Server? How to Find Out

Pinal Dave
SQL Tips and Tricks
SQL Audit, SQL Log, SQL Scripts, SQL Server Configuration
No Comments

Who changed a server setting in SQL Server? The error log records what changed and when, and the default trace adds the login, the computer and the program. Tested with one harmless change that is put back at the end.

Continue Reading
Aug3

SQL SERVER – 2005 – Difference Between INTERSECT and INNER JOIN – INTERSECT vs. INNER JOIN

Pinal Dave
SQL Performance
SQL Joins, SQL Scripts
85 Comments

What is the difference between INTERSECT and INNER JOIN? Both can return common rows, and AdventureWorks examples show how the two compare.

Continue Reading
Previous 1 … 750 751 752 753 754 755 756 … 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