rajendra guptaMar 28, 20222 minDifference between SQL COUNT(*), COUNT(1), COUNT(column_name) In SQL SERVERWhat is the difference between COUNT(*), COUNT(1), and COUNT(column_name) in SQL Server? Read all about it here.
rajendra guptaMar 27, 20222 minWindows PowerShell Error - The file cannot be loaded because the execution of scripts is disabledAre you getting the error - The file cannot be loaded because the execution of scripts is disabled on this system in Windows PowerShell?
rajendra guptaMar 22, 20225 minSteps to troubleshoot high CPU utilization in SQL ServerThis article describes the steps to troubleshoot high CPU utilization in SQL Server.
rajendra guptaMar 21, 20223 minUnderstand SQL WHILE loop with examplesThis tutorial will explain what a while loop is in SQL. It will also explain how to use the SQL WHILE loop.
rajendra guptaMar 19, 20223 minHow to revert database changes using SQL Server Database SnapshotDid you accidentally delete, update or modify the incorrect data in the SQL database? Use SQL Server database snapshot for it. Read More.