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 |
How many databases Microsoft SQL server provides?
What is ms sql server reporting services?
Does a specific recovery model need to be used for a replicated database? : sql server replication
Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?
How to provide default values to stored procedure parameters?
What are the steps need to be take improve the speed of a SQLDATA Server?
What would be the Expected Salary For SQL Server Developer for 3 years exp. as per indian market?
Explain few of the new features of sql server 2008 management studio
One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h
How do I find the sql server version?
Explain what is analysis service repository?
what is the diffrence between Snap Shot and Transaction Replication
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)