What is the purpose of UPDATE STATISTICS?
Answers were Sorted based on User's Feedback
Answer / guest
Updates information about the distribution of key values for
one or more statistics groups (collections) in the specified
table or indexed view.
Is This Answer Correct ? | 8 Yes | 3 No |
Answer / sambashiva
This is used after inserting huge rows into table or deleting from a table the pages of the index will be not in the proper way so by running this thing we can bring them to proper way.
Is This Answer Correct ? | 0 Yes | 0 No |
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
What is the difference between sdf and mdf?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
What is sql injection? How to protect against sql injection attack?
What are the restrictions that views have to follow?
Differentiate between mongodb vs. Sql server?
Explain about merge replications?
Where is localdb stored?
How to change the data type of an existing column with "alter table" statements in ms sql server?
How check triggers in sql server?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
What are types of scd? : sql server analysis services, ssas