Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sam
statistics in SQL Server refers specifically to information
that the server collects about the distribution of data in
columns and indexes. This data in turn is used by the query
optimizer to determine the plan of attack for returning
results when you run a query. While in the majority of
cases SQL Server takes care of this statistical
recordkeeping for you automatically, it's useful to have
some understanding of what's going on, and to know when you
might need to intervene.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain what are commit and rollback in sql?
Can we use pragma autonomous_transaction in trigger?
How can we migrate from SQL server to SQL Azure?
How to use group functions in the select clause in ms sql server?
Where the sql logs gets stored? : sql server database administration
What do you understand by a stored procedure?
Explain hostprotectionattribute in sql server 2005?
Differentiate between sql temp table vs table variable?
Explain the dbcc pintable command when would you use it?
What is sql server agent and what are the two modes of authentication in sql server?
What is buffer cash and log cache in sql server?
How to choose all records from the table?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
What is difference between group by and having?
What is a sql join?
