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.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
System Configuration Checker WMI Error: Fixing SQL Server Setup
Setup stopped with a WMI message before installing anything? Here are the safe repair steps, in order, with a quick check at the end.
SQL SERVER – Interesting Observation of DMV of Active Transactions and DMV of Current Transactions
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.
SQL SERVER – Restore or Attach Database Without .NDF or .MDF is Not Possible
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.
Replacing Profiler Traces With Extended Events
Replacing Profiler traces with Extended Events starts with the question, a focused event session, and a bounded target that avoids needless load.
Standard DBA Reports You Can Write in T-SQL
Standard DBA reports can use T-SQL to show backup age, database sizes, job failures, login changes, and errors in one weekly review.
SQL SERVER – Fix Error 9803. Invalid data for type “numeric” – Data Type Mapping
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.
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.