rajendra guptaMar 292 minLearn SQL NOT IN OperatorThe 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
rajendra guptaMar 282 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 guptaFeb 261 minAn Overview of the SQL CHARINDEX function The SQL CHARINDEX function is used to find the position of a character or substring within a string.
rajendra guptaJan 181 minT-SQL Query to find SQL database age and number of tables in SQL ServerSQL Server - The following T-SQL statement helps find the SQL Database age based on the created date and number of tables.
rajendra guptaJan 172 minThe SQL NULLIF functionNULLIF is a SQL function that is used to compare two columns. Use NULLIF to compare two columns and return NULL if they are equal to each ot
rajendra guptaJan 121 minT-SQL query to check SQL Server min server memory(MB) and max server memory(MB)T-SQL query to check SQL Server min server memory(MB) and max server memory(MB)
rajendra guptaJan 101 minEnclose a list of values into single quotes from CSV for T-SQL query for SQL Server databaseEnclose a list of values into single quotes from CSV for T-SQL query for SQL Server database
rajendra guptaJan 61 minWhat is SET NOEXEC ON in the T-SQL statement?Do you want to compile the query without executing it? If yes, you can use SET NOEXEC ON at the beginning of the T-SQL statement.
rajendra guptaJan 61 minSQL Server Management Studio Query Commands completed successfully without any ResultsI 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?
rajendra guptaJan 51 minT-SQL statement to Enable and Disable XP_CMDSHELL using SP_CONFIGURE in SQL ServerThis article outlines the steps to Enable and Disable XP_CMDSHELL using the SP_CONFIGURE system stored procedure.
rajendra guptaJan 41 minT-SQL Script to generate Six Digit One Time Password (OTP)This blog will give a T-SQL script o create and use Six Digit One Time Password using the SQL Server RAND function
rajendra guptaDec 16, 20211 minApprox_Count_Distinct in SQL Server 2019 and Azure SQL DatabaseApprox_Count_Distinct in SQL Server 2019 and Azure SQL Database
rajendra guptaDec 12, 20212 minSQL Server table Columns with NULL and NOT NULL values This SQL article explains the SQL Server column property that has NULL or NOT NULL keywords specified in the CREATE OR ALTER table...
rajendra guptaDec 9, 20211 minIdentifying SQL Agent Job from the format - SQLAgent - TSQL JobStep (Job 0xC4A075BBC7D7FB4993E60371This article helps you get the SQL Server agent job name from the hexadecimal Job ID format. Let’s say you have deadlock information that...
rajendra guptaDec 9, 20211 minSQL Server - Find Business Days Between DatesRecently, my client asked me to calculate the date difference, excluding only Sunday. How do you calculate days using the T-SQL script?...
rajendra guptaDec 9, 20211 minFind SQL Server Statistics Updated DateThis SQL Server Tutorial talks about finding out the last Statistics Update Date in SQL Server. We all know that Statistics are vital for...
rajendra guptaDec 9, 20211 minGet a list of supported Time Zones in SQL Server and Azure SQL DatabaseDo you want to find out supported time zones in SQL Server and Azure SQL Database? If yes, get the query in this article. The...
rajendra guptaDec 9, 20211 minWhen my SQL Server database was restored ?When my SQL Server database was restored ?
rajendra guptaDec 8, 20212 minSQL Script to fix Orphan users in SQL Server databaseThis blog post explains Orphan user and provides a script to fix Orphan users in SQL Server database. The basic process to create a...