Answer / nutan sharma

Report Service manager
in built Reporting Feature Available in 2005

Answer / satyambabu

Adding New feature Reporing
Adding New DataTypes.
Support Mirror concepts.
Exception handling support.
Query analyzer placed to query editor

Answer / arun pandey

There are the New Feature

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.

Answer / 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.

Answer / namz

Major change is the integration of sql server 2005 with
the .NET framework.Now u can use either T-SQL or any of ur
favourite language like C#,J# or VB.Net

Answer / skumar

There are many features introduced.
1. XML data type
2. Synonym
3. Instead of Trigger on indexed views
4. CROSS APPLY
5. INTERSECT and EXCEPT statements
6. CTE (Common Table Expressions)
7. PIVOT and UNPIVOT
8. TRY...CATCH and RAISERROR
9. .NET CLR integration
10. Custom data types
11. New data types like NTEXT,NVARCHAR,NCHAR
12.64 bit platform
13.DDL Triggers
14. New functions like RANK(),DENSE_RANK() and ROW_NUMBER
15. MAX Keyword
16. Table variable

Answer / ramprasshanth

ROLL UP and CUBE are available in ms sql server 2005

Answer / mruganandam(guru) mca saranath

The some features of sql server 2005 are,

1.Database Mirroring
2.Online Restore
3.Online Indexing Operation
4.Fast Recovery
5.Standards based Information Access
6.Sql Server Information Access
7.Dedicated Administrator Connection
8.Snapshot Isolation(SI)
9.Data Partitioning
10.Replication Enhancements.
which are the top ten features of Database Administration
in Sql Server 2005.

Does the order of columns in update statements matter?

0 Answers  

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

0 Answers  

What is an example of a primary key?

0 Answers  

How to transfer Logins from SQL Server 2000 to 2005

2 Answers  

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

0 Answers  

Mention the differences between having and where clause.

0 Answers  

How to update muliple row in single query?

0 Answers   MCN Solutions,

What is the Control Flow in SSIS

0 Answers   HCL,

What is checkpoint in sql server?

0 Answers  

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers  

What are the type of joins? When do we use Outer and Self joins?

3 Answers  

What stored by the master?

0 Answers