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.

This blog troubleshoots SQL Server Error Msg 3132, Level 16, State 1 while backing up SQL Database.

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

SQL Database Error - BACKUP LOG cannot be performed because there is no current database backup

Troubleshoot “Database might contain bulk-logged changes that have not been backed up” in SQL Server

In SQL Server Always On Availability Group environment endpoint connection issue is a common problem and it needs to be resolved by...

I recently came across a strange issue where the query does not return any row in SQL Server Management Studio. How do we solve this issue?

This article will explain the steps to change the SQL Server Tempdb database data and log file physical location.

Suppose you created a new table in SQL Server or Azure SQL Database, and the query editor shows you the error message "Invalid Object Name"