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 method you can use to reduce the overhead of Reporting Services data sources?
Can we install sql server 2016 on windows 7?
What is the xml datatype?
What are the lambda triggers?
What is “asynchronous” communication in sql server service broker?
Explain about SQLOS?
Why we use trigger in sql server with example?
What is the difference between char and varchar2 datatype in sql?
What is etl - extraction, transformation, and loading?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
How does a profiler work?
What is the difference between a function and a stored procedure?
What are the benefits of filtered indexes?
Tell me what is difference between view and materialized view?
What is relationship? What number of sorts of relationship are there?