top of page
rajendra gupta
May 4, 20222 min read
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
1,876 views0 comments
rajendra gupta
May 3, 20222 min read
Read Session-Specific data from the memory-optimized temp tables
Convert memory-optimized temp tables into session-specific memory temp tables in SQL Server.
294 views0 comments
rajendra gupta
Apr 22, 20224 min read
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.
3,866 views3 comments
rajendra gupta
Apr 21, 20222 min read
Locks with SQL Server UPDATE STATISTICS WITH FULLSCAN
This article discusses how SQL Server locking works with the SQL Server Update Statistic command.
5,607 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...
9,060 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
793 views0 comments
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....
382 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.
24,308 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
118 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.
52,476 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?
131 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.
59,066 views1 comment
rajendra gupta
Mar 21, 20223 min read
Understand SQL WHILE loop with examples
This tutorial will explain what a while loop is in SQL. It will also explain how to use the SQL WHILE loop.
4,230 views0 comments
rajendra gupta
Mar 19, 20223 min read
How to revert database changes using SQL Server Database Snapshot
Did you accidentally delete, update or modify the incorrect data in the SQL database? Use SQL Server database snapshot for it. Read More.
581 views0 comments
rajendra gupta
Mar 10, 20223 min read
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
10,600 views2 comments
rajendra gupta
Feb 27, 20221 min read
An Overview of the SQL CHARINDEX function
The SQL CHARINDEX function is used to find the position of a character or substring within a string.
111 views0 comments
rajendra gupta
Feb 16, 20222 min read
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.
9,262 views0 comments
rajendra gupta
Feb 16, 20221 min read
SQL Server Execution Plan - Displays Estimated and Actual number of rows
This article focuses on getting the Displays Estimated and Actual number of Rows from the SQL Server Execution Plan. Read More
1,713 views0 comments
rajendra gupta
Feb 8, 20221 min read
SQL Database Backups using DBATools PowerShell Module
Want to learn how to set up a PowerShell DBA environment? Here's how to configure it for SQL Server backups. T
624 views0 comments
rajendra gupta
Feb 1, 20221 min read
Space used by Individual tables in SQL Server
Learn how to manage SQL Server space used by individual tables with this tutorial. Read more here.
310 views0 comments
bottom of page