Answer / hari

In 2005 More features is available
Database Mirroiring
CLR Integration(Common language Runtime ) Integration
Management Studio
SIS Package
mirror backup
DAC(Dedicate Administration Connection)

Answer / gyan ranjan

New Data Types.
Full Text Search
And many new key words

Answer / pradip jain

Top 10 Features for Database Administration

Feature


Description

Database Mirroring


Extend log shipping capabilities with the database mirroring
solution. You will be able to use database mirroring to
enhance availability of your SQL Server systems by setting
up automatic failover to a standby server.

Online Restore


With SQL Server 2005, database administrators are able to
perform a restore operation while an instance of SQL Server
is running. Online restore improves the availability of SQL
Server because only the data being restored is unavailable;
the rest of the database remains online and available.

Online Indexing Operations


The online index option allows concurrent modifications
(updates, deletes, and inserts) to the underlying table or
clustered index data and any associated indexes during index
data definition language (DDL) execution. For example, while
a clustered index is being rebuilt, you can continue to make
updates to the underlying data and perform queries against
the data.

Fast Recovery


A new faster recovery option improves availability of SQL
Server databases. Administrators can reconnect to a
recovering database after the transaction log has been
rolled forward.

Standards-based Information Access


Any object, data source, or business intelligence component
can be exposed using standards-based protocols such as SOAP
and HTTP—eliminating the need for a middle-tier listener,
such as IIS, to access a Web services interface that is
exposed by SQL Server 2005.

SQL Server Management Studio


SQL Server 2005 includes SQL Server Management Studio, a new
integrated suite of management tools with the functionality
to develop, deploy, and troubleshoot SQL Server databases,
as well as enhancements to previous functionality.

Dedicated Administrator Connection


SQL Server 2005 provides a dedicated administrator
connection that administrators can use to access a running
server even if the server is locked or otherwise
unavailable. This capability enables administrators to
troubleshoot problems on a server by executing diagnostic
functions or Transact-SQL statements.

Snapshot Isolation


Snapshot Isolation (SI) level is provided at the database
level. With SI, users can access the last committed row
using a transitionally consistent view of the database. This
capability provides greater scalability.

Data Partitioning


Data partitioning is enhanced with native table and index
partitioning that enables efficient manageability of large
tables and indexes.

Replication Enhancements


For distributed databases, SQL Server 2005 provides
comprehensive schema change (DDL) replication,
next-generation monitoring capabilities, built in
replication from Oracle to SQL Server, merge replication
over https, and significant merge replication scalability
and performance improvements. Additionally, the peer-to-peer
transactional replication feature improves support for data
scale out using replication.



Top 10 Features for Development

Feature


Description

Hosted CommonLanguage Runtime


With SQL Server 2005 developers can create database objects
using familiar languages such as Microsoft Visual C# .NET
and Microsoft Visual Basic .NET. Developers can also create
two new objects—user-defined types and aggregates.

Native XML Support


Native XML data can be stored, queried, and indexed in a SQL
Server database—allowing developers to build new classes of
connected applications around Web services and across any
platform or device.

ADO.NET version 2.0


From new support for SQL Types to Multiple Active Result
Sets (MARS), ADO.NET in SQL Server 2005 evolves dataset
access and manipulation to achieve greater scalability and
flexibility.

Security Enhancements


The security model in SQL Server 2005 separate users from
objects, provides fine-grain access, and enables greater
control of data access. Additionally, all system tables are
implemented as views, providing more control over database
system objects.

Transact-SQL Enhancements


SQL Server 2005 provides new language capabilities for
developing scalable database applications. These
enhancements include error handling, recursive query
capabilities, relational operator PIVOT, APPLY, ROW_NUMBER
and other row ranking functions, and more.

Reliable Messaging for Asynchronous Applications


Service Broker is a robust messaging infrastructure that
provides reliable transactional delivery of critical
messages between servers—with the scalable high-performance
that is expected with asynchronous queuing.

Visual Studio Integration


Tight integration with Microsoft Visual Studio and the .NET
Framework streamlines development and debugging of
data-driven applications. Developers can build database
objects, such as stored procedures, using any .NET language
and can seamlessly debug across .NET and Transact-SQL (TSQL)
languages.

Web Services


With SQL Server 2005 developers can develop Web services in
the database tier, making SQL Server a hypertext transfer
protocol (HTTP) listener and providing a new type of data
access capability for Web services-centric applications.

Embedded Reports


Use client-side reporting controls to embed real-time
reports into an application at design time.

Full-Text Search Enhancements


SQL Server 2005 supports rich, full-text search
applications. Cataloging capabilities provide greater
flexibility over what is cataloged. Query performance and
scalability have been improved dramatically, and new
management tools provide greater insight into the full-text
implementation.

Answer / monal

ONLINE INDEX CREATION
ONLINE BACKUP (WHICH IS HOT BACKUP IN ORACLE)

Answer / dinesh

In 2000 :database go offline,Index tuning wizard
In 2005:Database go off/online,Database tunning advisor
In 2008 :Same as 2005

Answer / mr. obvious

the version number!

When cursors are useful?

0 Answers  

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

0 Answers  

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

0 Answers  

What does nvl stand for?

0 Answers  

Explain how dts is used to extract, transform and consolidate data?

0 Answers  

What are the types of subquery?

0 Answers  

How to create an inline table-valued function?

0 Answers  

Explain DBMS, RDBMS?

6 Answers  

What's the difference between a primary key and a unique key?

4 Answers  

Can a synonym name of a table be used instead of a table name in a select statement?

0 Answers  

What is an etl file?

0 Answers  

Can two tables share the same primary key?

0 Answers