Creates a small database table called dog. This table, dog, has been normalized to 3NF. Two new tables have been added, breedLookup and colorLookup. Creates a new table dog_expanded that joins dog, ...

INNER JOIN sys.indexes AS i ON t.object_id = i.object_id INNER JOIN sys.partitions AS p ON i.object_id = p.object_id AND i.index_id = p.index_id INNER JOIN sys.partition_schemes AS s ON ...

To encrypt and decrypt a string we have a predefined functions in Sql Server 2008 that are easy to use. Suppose we want to save some data that doesn't need to be exposed as a plain text then in such ...