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
Can we use max in where clause?
What is the new security features added in sql server 2016? : sql server security
How to write a query with an inner join in ms sql server?
How to return the top 5 rows from a select query in ms sql server?
What is data source object?
Explain what are various ways to enhance the ssrs report?
how to invoke a trigger on demand? : Sql server database administration
what is the main function of a query parameter?
What is a file group?
Define indexes?
What are the different types of locks in the database?
How to create a simple user defined function in ms sql server?
What is data file in computer?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
Explain the rules for designing files and file groups in sql server?
