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 is deploy, process and build? : sql server analysis services, ssas
What is the openxml statement in sql server?
How to create a new schema in a database?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
What are the different Authentication modes in SQL Server and how can you change authentication mode?
What is the default server name for sql server?
What is the advantage of sql server?
When to use null data driven subscription?
What is the latest version of microsoft sql server?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
Who developed sql server?
What is create command?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
How to see the event list of an existing trigger using sys.trigger_events?