Jun 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
  • Hire Me
  • Health Check
Oct1

SQL SERVER – What Does WHERE 1=1 Mean in the Code?

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
6 Comments
One of the blog followers asked this question “The code written by my colleague has WHERE 1=1. What does it mean?” Well. You have seen people using it when they dynamically construct WHERE condition based on the input values. Let us create this dataset CREATE TABLE #t (emp_name VARCHAR(100), experience…
Read More
Sep30

SQL SERVER – What is Windows Internal Database Edition?

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
3 Comments
The more you read the more you learn. But some of the best learnings need not come from known sources. These can be accidental too. These learnings in my opinion involves tons of exploration which you would have never done before. This blog post today is something on the similar…
Read More
Sep29

SQL SERVER – Fix: SQL Server CPU Schedulers Offline

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL CPU
1 Comment
Performance troubleshooting are some of the most common things I get to see as part this blog. A number of you keep sending me interesting mails that keep me up-to-date on my learnings. Yes, it is tough to know everything, but at the same time, it is almost impossible to…
Read More
Sep28

SQL SERVER – Basic architecture of Transaction Logs

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Log
2 Comments
Readers bump into this blog because it tries to simplify some of the most complex topics into a digestible format. I am a strong believer of this and try to bring some of these topics from time-to-time. Even I find some of these topics confusing, if I can understand them…
Read More
Sep27

Interview Question of the Week #038 – What is Left Semi Join Showplan Operator?

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks
SQL Joins
No Comments
It is very common of interviewers to ask questions which are a bit off and sometimes not used in daily life.  Here is such question I heard the other dya. Question: What is Left Semi Join Showplan Operator? Answer:  There are few interesting kinds of joint operations exists when execution…
Read More
Sep26

SQL SERVER – How to Restore Corrupted Model Database from Backup?

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Error Messages
8 Comments
Another email from one of my blog reader, which made me think about the incorrect information which is available on the internet. Hi Pinal, I have corruption in model database and due to that SQL Service is not able to start. Here are the messages in SQL ERRORLOG 2015-09-23 21:45:07.00…
Read More
Sep25

SQL SERVER – Failed Rule “Valid DSN” and “Valid Database compatibility level and successful connection”

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Error Messages
82 Comments
I always try to keep myself up-to-date with latest release of SQL Server. As a part of that I wanted to upgrade my SQL Server 2016 CTP2.2 to CTP2.3 version. While doing in-place upgrade I was blocked with few error and I was not able to proceed. Here is the…
Read More
Previous 1 … 341 342 343 344 345 346 347 … 831 Next

SQL SERVER – What Does WHERE 1=1 Mean in the Code?

SQL SERVER – What is Windows Internal Database Edition?

SQL SERVER – Fix: SQL Server CPU Schedulers Offline

SQL SERVER – Basic architecture of Transaction Logs

Interview Question of the Week #038 – What is Left Semi Join Showplan Operator?

SQL SERVER - Failed Rule "Valid DSN" and "Valid Database compatibility level and successful connection" model-01

SQL SERVER – How to Restore Corrupted Model Database from Backup?

SQL SERVER – Failed Rule “Valid DSN” and “Valid Database compatibility level and successful connection”

Previous 1 … 341 342 343 344 345 346 347 … 831 Next

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 14 SQL Server database books and 109 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 an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@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.

Comprehensive Database Performance Health Check

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.


SQL Server Performance Tuning Practical Workshop

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.


  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com