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
@@ROWCOUNT in SQL Server
The system function @@ROWCOUNT is used to return the number of rows that were impacted by the last statement that was executed. The number of
It’s all about TempDB
Temporary user objects that are specifically created are stored in the tempdb system database, which is a global resource. They consist of temporary stored procedures,
DEFAULT CONSTRAINT for DATES
Default dates in legacy systems, particularly MySQL, were set to 0000-00-00. From version 5.6 on, MySQL stopped allowing users to enter these values without first
Complex Data Types – STRUCT
STRUCT in Hive is similar to STRUCT in the C programming language. It’s a record type that contains a collection of named fields that can
Big Data & SQL 