How to view existing indexes on an given table using sys.indexes?
No Answer is Posted For this Question
Be the First to Post Answer
Why we use the openxml clause?
What is the difference between TRUNCATE and DROP?
Write a sql query to sort on different column name according to the parameters passed in the function?
What do you understand by check constraint in sql server?
Explain what is the difference between a local and a global temporary table?
How do you open a cluster administrator?
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 is the difference between dropping a database and taking a database offline?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What are the different index configurations a table can have?
Explain the properties of the relational tables?
Tell me what are the essential components of sql server service broker?