what are the advanced features in sql 2008?
Answers were Sorted based on User's Feedback
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 |
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 |
When multiple after triggers are attached to sql table, how to control the order of execution?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
what is advantages in sql 2005 over sql 2000?
Describe the left outer join & right outer join. : sql server database administration
What are the different types of stored procedures?
How to create new databases with "create database" statements?
What is partition index in sql server?
How to concatenate two binary strings together?
Can you link only other SQL Servers or any database servers such as Oracle?
Can sql servers linked to other servers like oracle?
Does server sql treat char as a variable-length or fixed-length column?
How to get @@error and @@rowcount at the same time?