Is it possible to have clustered index on separate drive from original table location?


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

Post New Answer

More SQL Server Interview Questions

What is tablesample?

0 Answers  


What is statement level trigger?

0 Answers  


What is extent? Types of extents?

0 Answers  


After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )

3 Answers   CarrizalSoft Technologies, iGate,


Other than truncate statement, which other command can by-pass the trigger on the tables?

0 Answers  






How can i give the restrictions for the data entry, if i wish to enter only I ,II, III, IV in the grade actegory of student table?

3 Answers  


How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?

4 Answers   IBM,


Which virtual table does a trigger use?

8 Answers   TCS,


When is update_statistics command used?

0 Answers  


Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

7 Answers   TCS,


Explain powershell included in sql server 2008?

0 Answers  


What are the different authentication modes in sql server?

0 Answers  


Categories