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 the different types of Replication and why are they used?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
Where actually sql azure database is hosted?
Describe the functionalities that views support.
What are group functions in query statements in ms sql server?
What is meant by Active-Passive and Active-Active clustering setup?
What are basics of policy management?
What is 1nf 2nf?
Will count(column) include columns with null values in its count?
What are different backups available in sql server?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
Why is normalisation important?
What is the process of normalising?
What are the main sources of data?
What is 'Join' and explain its various types.