Interested to Buy Any Domain ? << Click Here >> for more details...
How many index can be created for single table
- 4 Answers
- 18287 Views
- CarrizalSoft Technologies, Verizon, I also Faced
- E-Mail Answers
Answer Posted / sanjay kumar dinda
Two types of indexes are there in SQL Server
1. Clustered Index
2. Non-Clustered Index
We can create only 1 Clustered index in a table as it re-
orders the data of the table
We can create upto 249 Non-Clustered index in a table...
| Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
What does the on delete cascade option do?
how to use DTS package in 2000,2005,2008 in sql server
How to verify the port number of the sql server?
What is 4nf in normalization form?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What are alternate keys?
What is nonclustered index with included columns ?
What is triggers and its types?
What do you think of this implementation? Can this be implemented better?
Explain timestamp datatype?
What are the advantages of passing name-value pairs as parameters?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
What are the advantages of using stored procedures in sql server?
Write the SQL query to drop, truncate and delete table.
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
