ISNULL function behaves differently in MySQL and Microsoft SQL Server. In MySQL, ISNULL tests whether the given expression is NULL. It returns 1 if the
Category: SQL Server
DATEDIFF_BIG Function in SQL Server
This function returns the number of times the specified date part boundaries were crossed between the supplied dates (as a signed big integer value). The
SQL Assignment-2
This is a simple test or assignment to see how comfortable someone is using SQL at the beginner to advanced level. Exercises of this nature
Reorganize vs Rebuild Indexes
DBAs frequently have to choose between rebuilding the indexes and reorganizing them. Depending on how fragmented the index is, one must make a choice. Reorganizing
SQL Server Pivot Table Example
The SQL Server pivot function allows you to visualize data comparisons, patterns, and trends by representing the data in a calculated, condensed, and analytical manner.
SQL Server – Job Completion Status
One of the often-used scripts that DBAs keep on hand must be the one that shows how far a session has advanced. The statement below
Big Data & SQL 