Recently I have been stumped by not cliaming unused space correctly even though after delete handful of rows on a table. You may be aware using SP_SPACEUSED will get you details such as : Column name Data type Description database_name nvarchar(128) Name
Read More...
As it sounds this is an interview question, but if you look at the logical level of nothing much changes. There are two major concerns using such way, Performance and Storage space. In this using fixed char fields can be queried faster than varchar fields.
Read More...
Snapshot backups are introduced in SQL Server 2005 version that uses: The underlying backup technology creates an instantaneous copy of the data that is being backed up. The instantaneous copying is typically accomplished by splitting a mirrored set of
Read More...