SQL Server provides the following types of tables that serve special purposes in a database:
Partitioned tables are tables whose data is horizontally divided into units which may be spread across more than one file group in a database.
Temporary tables are divided into two types,
-Local (Its visible only to their creators)
-Global (visible to any user and any connection)
The configuration of the server and all its tables in a special set of tables known as system tables.
A wide table is a table with a column set.
-Wide tables can define up to 30,000 columns.
-Applications can dynamically add and remove columns from wide tables.
-When data is added and removed from a wide table, performance can be affected.
Source: http://msdn.microsoft.com/en-u | Asked In: Sri Ram IT Services, Chennai |