Sql Server Database Maintenance Questions and Answers

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