Write down the syntax and an example for create, rename and delete index?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What are character string data types in ms sql server?

0 Answers  


What is BCP? When do we use it?

2 Answers  


You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

0 Answers  


What is partition in sql server?

0 Answers  


What happens if you add a new index to large table?

0 Answers  






How optimize sql query with multiple joins in sql server?

0 Answers  


What are the transaction properties?

0 Answers  


If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,


What is BLOCK statements in SQL?

0 Answers   HCL,


What is acid db?

0 Answers  


what is dbcc? : Sql server database administration

0 Answers  


How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

0 Answers  


Categories