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 dknf in normalization form?
List the different types of joins?
Explain aggregate functions?
What are the advantages of sql azure?
After removing a table from database, what other related objects have to be dropped explicitly?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
How to reaname table name without using sp_Rename in sql server..?
What happens if time-only values are provided as date and time literals?
How to download and install microsoft .net framework version 2.0?
What are sql server functions?
What are the purposes and advantages stored procedure?
What is rtm version in sql server?
What do you mean by cardinality?
What is difference between inner join and full join?
How you would rewrite the sql query to return the customerid sorted numerically?
