Troubleshooting SQL Server Agent on Linux

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

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

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

This article helps you to fix SQL Server Error: 18456, Severity: 14, State: 38, Reason: Failed to Open the Explicitly Specified Database.

Did you face the error - "VIEW SERVER STATE permission was denied on object 'server', database 'master' while executing the DMV. Read More

SQL Server Extended Events to track PAGE SPLITS in SQL Database

Troubleshooting SQL Server Error 9002 - The Transaction Log for Database is Full - Do you get error 9002? Read more for a handy guide.

I will show you why developers should avoid creating SQL Server stored procedures that start with SP_. Read More here

SQL Server memory-optimized tables are a great way to improve performance for table variables. Read More here

Convert memory-optimized temp tables into session-specific memory temp tables in SQL Server.

Read this article to learn how to optimize your SQL code by using memory-optimized tables instead of SQL Server temporary tables.

This article discusses how SQL Server locking works with the SQL Server Update Statistic command.

Are you getting the following Cached MSI file missing error (Error Code 0x84B20002) while trying to do SQL Server Service pack or...

SQL Server Query Optimization- Learn about the use of functions (DateDiff) in the Where clause. Learn how to tune these queries to run fast

Type conversion in expression may affect "Cardinality Estimate" in query plan choice

This article helps you to understand index scans Vs. Index with various examples.

This article describes the steps to troubleshoot high CPU utilization in SQL Server.

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

Learn about SQL Server key lookup performance and how to improve the performance of key lookup queries.