Answer Posted / mandar kavishwar
Indexes in databases are similar to indexes in books. In a
database,an index allows the database program to find data
in a table without
scanning the entire table.
There are two types of Index in MS-SQL.
1.Clustered
2.Non-Clustered
In MS-SQL Server 2005,
Only 1 Clustered & 249 Non-Clustered Possible.So (Total 250)
But in MS-SQL Server 2008,
Only 1 Clustered & 999 Non-Clustered Possible.(Total 1000)
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Is it important for a database administrator to understand the operating system and file access?
How to connect of datebase with sql express.?
Differentiate between truncate vs delete in mssql?
How to insert data with null values?
What are “phantom rows”?
How to insert data into an existing table?
Is the log file is a part of file group?
How do you manipulate data?
Explain the use of containers in ssis and also their types?
Explain indexing and what are the advantages of it?
Can the “if update (colname)” statement be used in a delete trigger?
How you can get the list of largest tables in a database?
Explain security with sql azure?
How exceptions can be handled in sql server programming?
What are .mdf files?
