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 to populate a table in sql server?
Define the term DML, DDL and DTL?
List the data types available in mssql?
Can binary strings be converted into numeric or float data types?
How many instances per computer are there in sql server 2000?
Can you type more than one query in the query editor screen at the same time?
Working with TLogs
Explain partitioned view?
What is the difference Between Sql-server 2000 & 2005
Explain why variables called the most powerful component of ssis?
What is @@error in sql?
What is default port number for sql server 2000?
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)