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
How to view the error log for any specific instance? : sql server database administration
How to create a login account in ms sql server to access the database engine using "create login" statements?
What is ssl in sql server?
What are the triggers in sql?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
You want to implement the many-to-many relationship while designing tables. How would you do it?
Explain indexes disadvantages?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
What is 5nf in normalization form?
What is sleeping status in sql server?
What are system databases into sql server (2005/2008)?
whats the maximum size of view state??
How can I change procedure name in sql server?
How do you identify a foreign key?
