Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

what are the new features of sql server 2005?

Question Posted / mruganandam(guru) mca saranath

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is snapshot report?

172

Explain transaction server explicit transaction?

974

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

1041

What is the maximum length of an alert name?

1038

How to invoke a trigger on demand?

1150

Define ACID properties in a Database?

1104

What is transaction server explicit transaction?

1089

What is tablesample?

1176

What authentication modes does sql server support?

1150

1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

2534

What is schemabinding a view?

971

difference between Clustered index and non clustered index ?

1037

What is 1nf normalization form?

1083

Determine how to use the inserted and deleted pseudo tables?

1043

How do you create a clustered index?

1129