Why would you call update statistics?


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

Post New Answer

More SQL Server Interview Questions

What are .mdf files?

0 Answers  


How to execute multiple stored procedures at one time in sql server?

0 Answers  


what is the difference between sql query and google query?

10 Answers   TCS,


Tell me what is the significance of null value and why should we avoid permitting null values?

0 Answers  


how to control the amount of free space in your index pages? : Sql server database administration

0 Answers  






what purpose does OPENXML clause have in sql server stored procedure?

1 Answers  


What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

0 Answers  


table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers  


What is trigger explain with program?

0 Answers  


which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM

5 Answers   Wipro,


What are filegroups in sql server?

0 Answers  


What is subquery? Explain the properties of a subquery?

0 Answers  


Categories