Dr Victoria Holt: life, the universe and everything

I was interested to see what all the SQL codenames were Sphinx - SQL Server 7.0 Plato - SQL Server 7.0 OLAP Services Shiloh - SQL Server 200...

Database Mail Catalog views display metadata about the status of e-mail messages processed by Database Mail. USE MSDB select * from sysmail...

This defines the product version numbering format for SQL Server. It is MM.nn.bbbb.rr which is defined as: MM - Major version nn - Minor ver...

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...