Answer Posted / anand k
One table can only one clustered index or primary key and
249 non-clustered index or unique key
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What is the use of “join” in sql server?
What are the different subsets of sql?
Why do we need different type of parameter?
What are types of subqueries?
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?
Would you store your query in a ssrs report or a database server? State the reason why?
What are the different types of stored procedures?
Explain the different types of backups available in sql server? : sql server database administration
Explain an incremental backup?
Can we use pragma autonomous_transaction in trigger?
What are the components of sql server service broker?
Do you know what is blocking?
What is the use of partition by in sql server?
What is sql server programming?
Why do we use functions?