When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?


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

Post New Answer

More SQL Server Interview Questions

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 Answers  


What is trigger and different types of Triggers?

0 Answers   QuestPond,


What is the difference between left and right outer join?

0 Answers  


How many types of attribute relationships are there? : sql server analysis services, ssas

0 Answers  


Explain filtered indexes benefits?

0 Answers  






what is checksum in sql server.........???

0 Answers   TCS,


What is thr feature of change data capture?

0 Answers  


Explain powershell included in sql server 2008?

0 Answers  


How do I debug a stored procedure in sql server?

0 Answers  


Can a function call a stored procedure in sql server?

0 Answers  


I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.

4 Answers   Satyam,


What is the Disadvantage of indexed sequential file.

0 Answers   HCL,


Categories