wht's the differece between sqlserver05 and sqlserver2000

Answer Posted / monal

SQL 2005: Database Snapshot, SNAPSHOT Isolation
Level, .NET, CLR, Online Backup, Online Index Building

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a fan-out query in SQL Azure?

99


You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

88


What is @@rowcount in sql?

552


What are trace flags and mention a few common trace flags used with sql server?

540


Define constraints and give an example of their use?

557






What is an etl file?

518


Explain about sql server login?

585


What is code near application topology?

197


What are the difference between “where” and “having” clause in sql server?

574


What is filtered index?

645


How to filter out duplications in the returning rows in ms sql server?

627


define and explain the differences between clustered and non-clustered indexes.

590


What is "scheduled jobs" or "scheduled tasks"?

548


What is left outer join in sql server joins?

546


How to declare a cursor with "declare ... Cursor" in ms sql server?

560