what are the new features of sql server 2005?
Answer Posted / dinesh from a1-technology
1)online indexing only in sql 2005.
2)CLR Integration with sql server 2005.
3)xml datatype in sql 2005.
4)More faster than sql 2000.
5)Inbuilt with ASP.NET 2005.
6)GetDate() function also working in function in 2005 sql.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What options are available to audit login activity? : sql server security
Tell me what is the stuff and how does it differ from the replace function?
What is cdc in sql server?
Can group functions be used in the order by clause in ms sql server?
Why truncate is ddl command?
How do I open port 1433?
What is t-sql script to take database offline – take database online.
Write down the syntax and an example for create, rename and delete index?
What language is sql server written in?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What will be the maximum number of indexes per table?
What are the new security features added in sql server 2012? : sql server security
What is isolation levels?
What is key set driven?
What is instead of dml trigger?