Dr Victoria Holt: life, the universe and everything

SQL Server 2008 R2 was released to Released to Manufacturing on 21 April 2010. The official press release summarizes the main benefits as: 1...

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