SQL Server Queries to troubleshoot Memory pressure on SQL instance
SQL Server memory pressure can cause a lot of problems. This is a list of queries you can run to troubleshoot memory pressure problems. Read
rajendra gupta
- Jul 12
- 1 min
SQL SERVER script to get Database Backup History
Here is a SQL Server script that will get you the database backup history for a server. It is a significant troubleshooting step to determin
79 views0 comments
rajendra gupta
- Jul 12
- 1 min
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 out how to fix SQL
217 views0 comments
rajendra gupta
- Jul 8
- 1 min
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 Specified Database.
114 views0 comments
rajendra gupta
- Jul 8
- 1 min
SQL Server Error VIEW SERVER STATE permission was denied on object 'server’,databasE'Master'
Did you face the error - "VIEW SERVER STATE permission was denied on object 'server', database 'master' while executing the DMV. Read More
200 views0 comments
rajendra gupta
- Jun 30
- 2 min
SQL Server Extended Events to track PAGE SPLITS in SQL Database
SQL Server Extended Events to track PAGE SPLITS in SQL Database
73 views0 comments
rajendra gupta
- May 18
- 2 min
A handy guide for Troubleshooting SQL Server Error 9002 - The Transaction Log for Database is Full
Troubleshooting SQL Server Error 9002 - The Transaction Log for Database is Full - Do you get error 9002? Read more for a handy guide.
618 views0 comments
rajendra gupta
- May 11
- 2 min
Why developers should avoid creating SQL Server Stored Procedure prefix SP_
I will show you why developers should avoid creating SQL Server stored procedures that start with SP_. Read More here
161 views0 comments
rajendra gupta
- May 4
- 2 min
SQL Server MeMORY Optimized Table Variables for faster performance
SQL Server memory-optimized tables are a great way to improve performance for table variables. Read More here
468 views0 comments
rajendra gupta
- May 3
- 2 min
Read Session-Specific data from the memory-optimized temp tables
Convert memory-optimized temp tables into session-specific memory temp tables in SQL Server.
96 views0 comments
rajendra gupta
- Apr 22
- 4 min
Use Memory Optimization for Faster temp table performance
Read this article to learn how to optimize your SQL code by using memory-optimized tables instead of SQL Server temporary tables.
435 views3 comments
rajendra gupta
- Apr 21
- 2 min
Locks with SQL Server UPDATE STATISTICS WITH FULLSCAN
This article discusses how SQL Server locking works with the SQL Server Update Statistic command.
604 views0 comments
rajendra gupta
- Apr 14
- 3 min
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...
1,021 views0 comments
rajendra gupta
- Apr 13
- 3 min
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
232 views0 comments
rajendra gupta
- Mar 31
- 3 min
Type conversion in expression may affect "Cardinality Estimate" in querY plan choice
Type conversion in expression may affect "Cardinality Estimate" in query plan choice
1,789 views0 comments
rajendra gupta
- Mar 30
- 3 min
SQL Server Performance Tuning – Index Scan vs. Index Seek
This article helps you to understand index scans Vs. Index with various examples.
800 views0 comments
rajendra gupta
- Mar 22
- 5 min
Steps to troubleshoot high CPU utilization in SQL Server
This article describes the steps to troubleshoot high CPU utilization in SQL Server.
10,543 views0 comments
rajendra gupta
- Mar 10
- 3 min
Why my SQL Server tempdb database Is Growing Fast?
Have you ever wondered why your tempdb database is growing so fast? This article explores how to find the culprit SPID that is causing tempd
1,010 views0 comments
rajendra gupta
- Feb 16
- 2 min
Key (Lookup) in SQL Server Key Lookup performance
Learn about SQL Server key lookup performance and how to improve the performance of key lookup queries.
327 views0 comments
rajendra gupta
- Jan 18
- 1 min
Troubleshoot SQL Server Backup Error Msg 3231, Level 16, State 1
When you are experiencing SQL Server Error Msg 3231, Level 16, State 1 while backing up SQL Database, it is important to troubleshoot the er
38 views0 comments