what are the advanced features in sql 2008?

Answers were Sorted based on User's Feedback



what are the advanced features in sql 2008?..

Answer / sagi.rahul

New Advanced Features In SQL Server 2008: -
a. New Data Types (Date, Time, Spatial, FILESTREAM &
HIERARCHYID)
b. Resource Governor
c. Backup Compression
d. Data Compression
e. Policy-based Management
f. Filestreamdata

Is This Answer Correct ?    2 Yes 0 No

what are the advanced features in sql 2008?..

Answer / neetika

QL Server Management Studio has the following improvements:

® In the Query Editor window, you can query multiple servers at the same time by opening query windows from registered server groups. The query results can be combined into a single results pane, or can be returned in separate results panes.
® You can access SQL Server Profiler from the Query Editor window, from the Query menu, the Query Editor toolbar, or by pressing CTRL+ALT+P.
® You can now open tables by using a Return Top n rows option.
® On the Tools/Option menu, you can specify the action that results by double-clicking tables in Object Explorer.

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More SQL Server Interview Questions

When multiple after triggers are attached to sql table, how to control the order of execution?

0 Answers  


Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

0 Answers  


what is advantages in sql 2005 over sql 2000?

4 Answers  


Describe the left outer join & right outer join. : sql server database administration

0 Answers  


What are the different types of stored procedures?

0 Answers  






How to create new databases with "create database" statements?

0 Answers  


What is partition index in sql server?

0 Answers  


How to concatenate two binary strings together?

0 Answers  


Can you link only other SQL Servers or any database servers such as Oracle?

1 Answers  


Can sql servers linked to other servers like oracle?

0 Answers  


Does server sql treat char as a variable-length or fixed-length column?

0 Answers  


How to get @@error and @@rowcount at the same time?

0 Answers  


Categories