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
How to select some specific columns from a table in a query in ms sql server?
List the types of recovery model available in sql server?
What is the difference between set and select?
What happens if the update subquery returns no rows in ms sql server?
What is a raid and what are different types of raid configurations?
What is difference between drop truncate and delete?
How to edit table in sql server 2017?
What are the types of user defined functions in sql server?
What are the advantages to use stored procedures?
How can you control the amount of free space in your index pages?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
What you can do to delete a table without the delete trigger firing?
What is normalization? Explain different forms of normalization?
What is sql server schema compare? How we can compare two database schemas?
What is difference between count (*) and count 1?