Error while SQL Server Service Pack or Cumulative Updates: “Cached MSI file is missing”
Are you getting the following Cached MSI file missing error (Error Code 0x84B20002) while trying to do SQL Server Service...
Category: Others
117 articles
Different ways to check the last Restart time of SQL Server
Knowing when your SQL Server instance was last started can be helpful for various reasons. In this tip, we will...
SQL Server Performance Tuning – Index Scan vs. Index Seek
SQL Server performance tuning has always been a tricky task. It is especially true when you’re using indexes. With clustered...
SQL Server Database Mirroring Login Attempt Failed with Error ‘Connection Handshake Failed’
In SQL Server Always On Availability Group environment endpoint connection issue is a common problem and it needs to be...
SQL Server Error 18456: failed to open the explicitly specified database
This article helps you to fix SQL Server Error: 18456, Severity: 14, State: 38, Reason: Failed to Open the Explicitly...
Fix SQL Server error: SHOWPLAN permission denied in database ‘DBName’
Do you get the error “SHOWPLAN permission denied in database ‘DBName'”? This error is due to SQL Server permissions. Find...
Difference between SQL COUNT(*), COUNT(1), COUNT(column_name) In SQL SERVER
What is the difference between COUNT(*), COUNT(1), and COUNT(column_name) in SQL Server? Read all about it here. The SQL COUNT()...