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
Detail about query optimizer?
How many triggers are possible per table?
What does asynchronous call backs means?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
How you can get a list of all the table constraints in a database?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
Do you know what is sql service broker?
How do I clean up sql server transaction log?
What is 1nf 2nf?
How to access the deleted record of an event?
What happens if null values are involved in datetime operations?
What is the use of partition by in sql server?
Are semicolons required at the end of sql statements in sql server 2005?
What are Spatial data types in SQL Server 2008
What are window functions in sql server?