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
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What are policy management terms?
Explain the different types of joins?
Can we insert data into view sql server?
What is the command to change the recovery model?
What are the advantages of user-defined functions over stored procedures in sql server?
How to see existing views in ms sql server?
What are trace flags and mention a few common trace flags used with sql server?
What is function of CUBE ?
What is merge statement?
Do you know sql server 2008 introduces automatic auditing?
tell me the disaster recovery plan
Do you know what is lock escalation?
What is a trace frag? Where do we use it?
How to delete multiple rows with one delete statement in ms sql server?