Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Features in SQLServer 2005 Expand / Collapse
Author
Message
Posted Thursday, March 13, 2008 4:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, March 13, 2008 4:44 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 7, 2014 4:03 AM
Points: 122, Visits: 145
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.
Post #468590
Posted Thursday, March 13, 2008 6:53 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:38 AM
Points: 13,755, Visits: 28,147
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
Posted Friday, March 14, 2008 12:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase

Permissions Expand / Collapse