Dr Victoria Holt: life, the universe and everything

Taxonomy is the science of classification. It comes from the Greek taxis meaning arrangement or division and nomos meaning law. It provides...

Fragmentation is the storing of data non-contiguously on disk. Detecting Fragmentation The level of fragmentation can be determined by runni...

There are various types of data Structured Data is data which is stored in a relational database Semi Structured Data is often of xml type...

There are 3 roles Mdw_admin Grants read and write to the Management Data Warehouse (MDW). It allows users to purge and clean up jobs to mana...

This product is a development of performance dashboard, database reports and built on top of standard DMV's. Historical data is persiste...

A script to Stop and Start the SQL Server Agent Service -- Check status EXEC xp_servicecontrol 'QUERYSTATE','SQLServerAGENT'...

There are 2 ways to run SQL Profiler • Run the SQL Profiler client tool through the GUI • Server-side tracing where events are saved t...