top of page
rajendra gupta
Apr 19, 20223 min read
Explore WITH(NOLOCK)and the difference between NOLOCK and WITH(NOLOCK)SQL Server Table hint
SQL Server Table hint WITH(NOLOCK) and the difference between NOLOCK and WITH(NOLOCK)
* Are you using NOLOCK or WITH(NOLOCK) in SQL Server?
10,884 views0 comments
rajendra gupta
Apr 14, 20223 min read
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 pack or...
8,574 views0 comments
rajendra gupta
Apr 13, 20223 min read
SQL Server Query Optimization- Effective use of functions in the Where clause
SQL Server Query Optimization- Learn about the use of functions (DateDiff) in the Where clause. Learn how to tune these queries to run fast
783 views0 comments
rajendra gupta
Mar 31, 20223 min read
Type conversion in expression may affect "Cardinality Estimate" in querY plan choice
Type conversion in expression may affect "Cardinality Estimate" in query plan choice
15,893 views1 comment
rajendra gupta
Mar 31, 20221 min read
Query to list SQL Server indexes in a specific database
Sometimes you need to know the list of SQL Server indexes available in the SQL database. There are many ways to get the list of indexes....
370 views0 comments
rajendra gupta
Mar 30, 20223 min read
SQL Server Performance Tuning – Index Scan vs. Index Seek
This article helps you to understand index scans Vs. Index with various examples.
23,685 views0 comments
rajendra gupta
Mar 29, 20222 min read
Learn SQL NOT IN Operator
The SQL NOT IN operator is used to find entries in a table that are not in a list of values. Learn how to use this SQL operator
116 views0 comments
rajendra gupta
Mar 28, 20222 min read
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.
51,925 views0 comments
rajendra gupta
Mar 27, 20222 min read
Windows PowerShell Error - The file cannot be loaded because the execution of scripts is disabled
Are you getting the error - The file cannot be loaded because the execution of scripts is disabled on this system in Windows PowerShell?
129 views0 comments
rajendra gupta
Mar 22, 20225 min read
Steps to troubleshoot high CPU utilization in SQL Server
This article describes the steps to troubleshoot high CPU utilization in SQL Server.
58,288 views1 comment
bottom of page