wat is the main diff between sql server 2000and sql server 2005

Answer Posted / dinesh

In 2000 :database go offline,Index tuning wizard
In 2005:Database go off/online,Database tunning advisor
In 2008 :Same as 2005

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between a having clause and a where clause.

522


How to use go command in "sqlcmd"?

644


What are the difficulties faced in cube development? : sql server analysis services, ssas

607


What is difference between line feed ( ) and carriage return ( )?

522


Which sql server table is used to hold the stored procedure scripts?

614






What is fill factor and pad index?

542


What is #table in sql server?

537


What is log shipping?

560


What is optimistic concurrency?

563


How you can change a cross join into an inner join?

553


how you can configure a running aggregate in SSRS?

112


Can you explain about buffer cash and log cache in sql server?

504


What is subquery? Explain the properties of a subquery?

511


What is failover clustering overview?

593


 Explain what is sql override for a source taLle in a mapping?

571