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 |
What is policy based management (pbm)? : sql server database administration
What are the different types of collation sensitivity in sql server?
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
Advantages and disadvantages of stored procedures.
How you can minimize the deadlock situation?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
can you any body tell me which service pack is installed in the sql server?
What is a cursor in SQL Server 2000 and their types?
Explain how to integrate the ssrs reports in application?
How many triggers you can have on a table?
What is clustered index
What is sql server agent and what are the two modes of authentication in sql server?