what is advantages in sql 2005 over sql 2000?
Answers were Sorted based on User's Feedback
Answer / ashis
Sql server 2005 have some new data types like varchar
(max),xml. Sql server 2005 have SSIS instead of dts in sql
server 2000. SSRS with adhoc reporting. Some sys command
are changed like sys.objects, sys.columns.
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / gowthami radhakrishnan
sql server 2005 replaces query analyser and enterprise
manager with management studio
Is This Answer Correct ? | 5 Yes | 2 No |
Answer / adhi
Database mirriong
database snapshot
CLR integration
DDL Trigger
Schema
we can install up to up 50 instance (in 2000 only 16)
Try& CATCH
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / subbu
Newly introduced in Sql server 2005
======================================
DDL trigger (This trigger fired only create new table or
Drop table or Alter table).Created in either Database or
Server.
To Deploy .Net procedures.
CLR Integration.
TRY & CATCH Mehod (For Error Handling).
Is This Answer Correct ? | 2 Yes | 2 No |
When we should use and scope of @@identity?
Can we create clustered index on non primary key column
20 Answers ABC, CTS,
Difference between Triggers and Stored Procedure
23 Answers Claimat, HCL, Protech, Silgate,
Explain filtered indexes benefits?
What is the purpose of optimization?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
How do you use DBCC statements to monitor various aspects of a SQL server installation?
How much space does sql server 2016 take?
How to tune a stored procedure?
What is the difference between UNIQUE and DISTINCT keywords in DBMS?
How do you debug a procedure in sql server?
Distinguish between commit and rollback?