Features in SQLServer 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » Features in SQLServer 2005

Features in SQLServer 2005

Rate Topic

Display Mode

Topic Options

Author

Message

nithya.article

Posted Thursday, March 13, 2008 4:32 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, March 14, 2008 12:39 AM
Points: 2, Visits: 1

Hi Friends,

I have joined newly to this group.I need information about SQLServer 2005 features in interview point.
Need some points to say in interview.Because i am very poor DB Developer. So can you guys help me in this plssssssssssssss.

Regards
Nithya Raghu

Post #468588

Sarvesh Kumar Gupta

Posted Thursday, March 13, 2008 4:44 AM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, February 02, 2012 2:26 AM
Points: 86, Visits: 94

Hi,

Following are the some Features in Sql Server 2005:

1. integration of your back-end systems and data transfer across firewalls using XML.
2. Scale your applications up to 32 CPUs and 64 gigabytes (GB) of RAM. SQL Server 2005 has demonstrated record-breaking performance that you can leverage.
3. With SQL Server 2005 you can implement merge, transactional, and snapshot replication with heterogeneous systems.
4. Online Operations (Index Operations and Restore)
5. Snapshot Isolation

For more knowledge go through below link:
http://www.microsoft.com/sql/prodinfo/overview/whats-new-in-sqlserver2005.mspx. Cool

Post #468590

Grant Fritchey

Posted Thursday, March 13, 2008 6:53 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 3:41 AM
Points: 13,383, Visits: 25,189

But to be utterly honest here, simply reeling off a few buzz words about what's new in SQL 2005 won't get you very far in an interview around most of the DBA's that I know. For example, 2005 introduced a new method for handling errors in TSQL using TRY/CATCH. If you tell me this, I'm now going to follow up and say "Really? Can you step over to that white board there and show me how they work?"

If you bring up information in an interview, you need to be prepared to back it up.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #468642

nithya.article

Posted Friday, March 14, 2008 12:49 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, March 14, 2008 12:39 AM
Points: 2, Visits: 1

Thanks a lot for the responses. I think i need to dig the features in SQL Server 2005.
As a developer i need to know more about development features. Thxs to Sarvesh Kumar Gupta, for sent me the microsoft article.

Regards
Nithya

Post #469206

« Prev Topic | Next Topic »

Permissions