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
Category: RDBMS
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
@@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
Big Data & SQL 