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

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.

What is the difference between DATETIME2 and DATETIME?

1 Answers   Infosys,

---

Difference between server.transfer and server.execute method?

2 Answers  

---

How to transfer a table from one schema to another?

1 Answers   MCN Solutions,

---

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

1 Answers  

---

What is meant by dirty read?

1 Answers  

---

How can you ensure that the database and sql server based application perform well?

1 Answers  

---

What is partition, how will you implement it? : sql server analysis services, ssas

1 Answers  

---

What are the properties of sub-query?

1 Answers  

---

How to select nth record from a table?

13 Answers   DELL, Microsoft, Ramco,

---

Name few of the dcl commands in sql?

1 Answers  

---

How to delete an existing database user?

1 Answers  

---

What is a schema in ms sql server 2005?

1 Answers  

---