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
What is save transaction and save point?
What are the benefits and tasks of object explorer? : sql server management studio
Distinguish between nested subquery and correlated subquery?
How to display a past time in days, hours and minutes?
What do you mean by 'normalization'?
What is Lock table in SQL?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
what purpose does the model database serve? : Sql server database administration
Can one drop a column from a table?
How to generate create view script on an existing view?
What are the types of dml?
Explain system views?
How many categories of functions based their return modes?
How to get a list of all tables with "sys.tables" view in ms sql server?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?