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
top of page
-
- Jul 12, 2022
- 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
694 views0 comments
-
- Jul 12, 2022
- 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
2,973 views0 comments
-
- Jul 8, 2022
- 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.
2,756 views0 comments
-
- Jul 8, 2022
- 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
1,169 views0 comments
-
- Jun 30, 2022
- 2 min
SQL Server Extended Events to track PAGE SPLITS in SQL Database
SQL Server Extended Events to track PAGE SPLITS in SQL Database
173 views0 comments
-
- May 18, 2022
- 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.
724 views0 comments
-
- May 11, 2022
- 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
220 views0 comments
-
- May 4, 2022
- 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
713 views0 comments
-
- May 3, 2022
- 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.
138 views0 comments
-
- Apr 22, 2022
- 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.
1,507 views3 comments
-
- Apr 21, 2022
- 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.
1,740 views0 comments
-
- Apr 14, 2022
- 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,927 views0 comments
-
- Apr 13, 2022
- 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
314 views0 comments
-
- Mar 31, 2022
- 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
4,590 views0 comments
-
- Mar 30, 2022
- 3 min
SQL Server Performance Tuning – Index Scan vs. Index Seek
This article helps you to understand index scans Vs. Index with various examples.
3,204 views0 comments
-
- Mar 22, 2022
- 5 min
Steps to troubleshoot high CPU utilization in SQL Server
This article describes the steps to troubleshoot high CPU utilization in SQL Server.
20,004 views0 comments
-
- Mar 10, 2022
- 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,987 views0 comments
-
- Feb 16, 2022
- 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.
752 views0 comments
-
- Jan 18, 2022
- 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
53 views0 comments
bottom of page