Answer Posted / b.r.reddy
We can manually set the statistical values.
We can gather statistics in parallel mode.
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How do you open a cluster administrator? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
how can you create a user-defined lock?
What are the commands you'd issue to show the explain plan for "select * from dual"?
What the different types of replication and why are they used? : sql server DBA
What is fill factor? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
Why would you call update statistics? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What is the importance of a recovery model? : sql server DBA
what is a crs resource?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
How to start SQL Server in minimal configuration mode?
What the different topologies in which replication can be configured? : sql server DBA