Category: DBA Worries Continued
-
DBA Worries Continued DBMS Concepts L1 DBA My SQL MySQL Architecture MySQL Basics MySQL L1 SQL Server
Deterministic and Nondeterministic Functions
Deterministic functions: Deterministic functions always result in the same output every time they are called with a fixed set of input values and given the same condition of the database. For example, AVG() function always results the same result given the qualifications stated above. Nondeterministic functions: Nondeterministic functions result in different output each time they…
//
-
Fragmentation
Hey guys, In this blog I am going to explain you about Fragmentation and its types and how to detect fragmentation and fix it. SQL Server index fragmentation is a common source of database performance degradation. Fragmentation occurs when there is a lot of empty space on a data page (internal fragmentation) or when the logical…
//
-