|
Differential backups are a faster mechanism of taking backups. The back up taken is only of the recently made changes in the data from the last differential backup taken.......
|
|
DBCC performs a check on the tables and views for any corruptions. The command DBCC CHECKTABLE checks for integrity of the data, index, text, ntext, and image pages.......
|
|
An index view has a unique clustered index created on it. They exist as rows on the disk. Because they are saved on the disk......
|
|
Partitioned view: Partitioned view joins the horizontally portioned data. This data may belong to one ore more servers. It makes the data appear as one table........
|
|
A full text index has an index of type FULL TEXT. Full text indexing can only done for CHAR, VARCHAR, or TEXT columns........
|
|
Database files are used for mapping the database over some operating system files. Data and log information are separate......
|
|
User defined data types are most commonly used when consistency among several tables storing the same type of data is desired........
|
|
Indexes can be placed on different file groups to increase performance. By default, indexes are created on the same file group as the base table........
|
|
INSTEAD OF Triggers: Cause the trigger to fire instead of executing the triggering event or action. It prevents unnecessary changes to be made.......
|
|
Use indexes. Specify only the columns necessary while using select query.......
|
