Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is an indexing technique?
What are the 10 characteristics of data quality?
How do I create a stored procedure in dbml?
What are ddl (data definition language) statements for tables in ms sql server?
What are page splits? : SQL Server Architecture
What is the report model project?
What is a scheduled job or what is a scheduled task?
What are trace flags and mention a few common trace flags used with sql server?
What are the key configuration files for sql server reporting services ?
What is RMS migrations?
Which language is supported by sql server?
How to replace given values with null using nullif()?
What is serializable?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
How to link tables in sql server?
