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
Apr13

Introduction to JOINs in SQL Server: INNER, OUTER and CROSS JOIN

Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Joins, SQL Scripts, SQL User Group
401 Comments

This introduction to JOINs shows INNER, LEFT, RIGHT, FULL and CROSS JOIN with Venn diagrams and real results from two small tables. It also covers finding rows with no match and three traps that catch people. I first wrote it for members of the Gandhinagar SQL Server User Group.

Continue Reading
Apr12

System Configuration Checker WMI Error: Fixing SQL Server Setup

Pinal Dave
SQL Tips and Tricks
Bug Fix, SQL Server Installation, SQL Setup, WMI
6 Comments

Setup stopped with a WMI message before installing anything? Here are the safe repair steps, in order, with a quick check at the end.

Continue Reading
Apr11

SQL SERVER – Interesting Observation of DMV of Active Transactions and DMV of Current Transactions

Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL System Table, SQL Transactions
3 Comments

sys.dm_tran_active_transactions and sys.dm_tran_current_transaction look alike, but one lists active transactions for the instance, the other only your session.

Continue Reading
Apr10

SQL SERVER – Restore or Attach Database Without .NDF or .MDF is Not Possible

Pinal Dave
SQL Tips and Tricks
Database, SQL Backup and Restore, SQL Data Storage, SQL Error Messages
10 Comments

Can you restore or attach database files if the .mdf or an .ndf file is missing? In one word, no. Here is why every data file is needed.

Continue Reading
Apr10

Replacing Profiler Traces With Extended Events

Pinal Dave
SQL Tips and Tricks
SQL Extended Events, SQL Monitoring, SQL Profiler, SQL Server, SQL Trace
No Comments

Replacing Profiler traces with Extended Events starts with the question, a focused event session, and a bounded target that avoids needless load.

Continue Reading
Apr10

Standard DBA Reports You Can Write in T-SQL

Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, SQL Monitoring, SQL Server, SQL Server Agent
2 Comments

Standard DBA reports can use T-SQL to show backup age, database sizes, job failures, login changes, and errors in one weekly review.

Continue Reading
Apr9

SQL SERVER – Fix Error 9803. Invalid data for type “numeric” – Data Type Mapping

Pinal Dave
SQL Tips and Tricks
Oracle, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Security
8 Comments

My present article talks about an error that you will encounter when connecting to Oracle database using OPENQUERY. Let us learn about how to fix error 9803.

Continue Reading
Previous 1 … 711 712 713 714 715 716 717 … 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