Interested to Buy Any Domain ? << Click Here >> for more details...
what are the new features of sql server 2005?
- 8 Answers
- 13274 Views
- HP, Keane India Ltd, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nutan sharma
Report Service manager
in built Reporting Feature Available in 2005
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / satyambabu
Adding New feature Reporing
Adding New DataTypes.
Support Mirror concepts.
Exception handling support.
Query analyzer placed to query editor
| Is This Answer Correct ? | 3 Yes | 0 No |
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.
| Is This Answer Correct ? | 2 Yes | 1 No |
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.
| Is This Answer Correct ? | 1 Yes | 0 No |
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
| Is This Answer Correct ? | 2 Yes | 2 No |
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
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ramprasshanth
ROLL UP and CUBE are available in ms sql server 2005
| Is This Answer Correct ? | 0 Yes | 0 No |
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
How many ways to create table-valued functions?
What is difference between cte and view?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
Explain filestream storage of sql server 2008?
How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ mak2786@gmail.com
35 Answers Oracle, Scend, TechInfini,
what are user defined datatypes? : Sql server database administration
What is update locks?
What are clustered and non-clustered index?
what is Covering Index ?
What are constraints? Explain different types of constraints?
26 Answers Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro,
How to find out name of all employees who has salary less than 200 Rs.?
Explain in brief about Microsoft SQL server?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
