WhatsApp Image 2021-11-26 at 4.32_edited.png
WhatsApp Image 2021-12-01 at 1.18_edited.png
  • Home

  • About Me

  • SQL Server

  • Cloud

    • Azure
    • AWS
  • All Blogs

  • Courses

  • More

    Use tab to navigate through the menu items.
    Mail
    • LinkedIn
    • Facebook
    • Twitter
    • Twitter
    Why developers should avoid creating SQL Server Stored Procedure prefix SP_
    rajendra gupta
    • 5 days ago
    • 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
    87 views0 comments
    SQL Server MeMORY Optimized Table Variables for faster performance
    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
    302 views0 comments
    Read Session-Specific data from the memory-optimized temp tables
    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.
    68 views0 comments
    Use Memory Optimization for Faster temp table performance
    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.
    201 views3 comments
    Locks with SQL Server UPDATE STATISTICS WITH FULLSCAN
    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.
    255 views0 comments
    Error while SQL Server Service Pack or Cumulative Updates: "Cached MSI file is missing”
    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...
    466 views0 comments
    SQL Server Query Optimization- Effective use of functions in the Where clause
    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
    183 views0 comments
    Type conversion in expression  may affect "Cardinality Estimate" in querY plan choice
    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
    220 views0 comments
    SQL Server Performance Tuning – Index Scan vs. Index Seek
    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.
    244 views0 comments
    Steps to troubleshoot high CPU utilization in SQL Server
    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.
    6,111 views0 comments
    Why my SQL Server tempdb database Is Growing Fast?
    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
    645 views0 comments
    Key (Lookup) in SQL Server Key Lookup performance
    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.
    183 views0 comments
    Troubleshoot SQL Server Backup Error Msg 3132, Level 16
    rajendra gupta
    • Jan 17
    • 1 min

    Troubleshoot SQL Server Backup Error Msg 3132, Level 16

    This blog troubleshoots SQL Server Error Msg 3132, Level 16, State 1 while backing up SQL Database.
    39 views0 comments
    Troubleshoot SQL Server Backup Error Msg 3231, Level 16, State 1
    rajendra gupta
    • Jan 17
    • 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
    29 views0 comments
    SQL Database Error - BACKUP LOG cannot be performed because there is no current database backup
    rajendra gupta
    • Jan 12
    • 1 min

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

    SQL Database Error - BACKUP LOG cannot be performed because there is no current database backup
    5 views0 comments
    Troubleshoot “Database might contain bulk-logged changes that have not been backed up” in SQL Server
    rajendra gupta
    • Jan 12
    • 1 min

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

    Troubleshoot “Database might contain bulk-logged changes that have not been backed up” in SQL Server
    14 views0 comments
    SQL Server Database Mirroring Login Attempt Failed with Error ‘Connection Handshake Failed’
    rajendra gupta
    • Jan 6
    • 1 min

    SQL Server Database Mirroring Login Attempt Failed with Error ‘Connection Handshake Failed’

    In SQL Server Always On Availability Group environment endpoint connection issue is a common problem and it needs to be resolved by...
    28 views0 comments
    SQL Server Management Studio Query Commands completed successfully without any Results
    rajendra gupta
    • Jan 6
    • 1 min

    SQL Server Management Studio Query Commands completed successfully without any Results

    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?
    15 views0 comments
    move SQL Server TempDB database files to a different directory using Dynamic SQL
    rajendra gupta
    • Jan 4
    • 3 min

    move SQL Server TempDB database files to a different directory using Dynamic SQL

    This article will explain the steps to change the SQL Server Tempdb database data and log file physical location.
    33 views0 comments
    "Invalid Object Name" Error in SSMS for recently created objects
    rajendra gupta
    • Jan 3
    • 1 min

    "Invalid Object Name" Error in SSMS for recently created objects

    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"
    17 views0 comments
    1
    2

    © 2022 by dbblogger

    Privacy Policy
    CopyRight