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
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..
What is trigger and different types of Triggers?
What is the difference between left and right outer join?
How many types of attribute relationships are there? : sql server analysis services, ssas
Explain filtered indexes benefits?
what is checksum in sql server.........???
What is thr feature of change data capture?
Explain powershell included in sql server 2008?
How do I debug a stored procedure in sql server?
Can a function call a stored procedure in sql server?
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.
What is the Disadvantage of indexed sequential file.