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 are the events recorded in a transaction log?

0 Answers  

---

What is indexing?

0 Answers   AOL,

---

How do I open port 1433?

0 Answers  

---

Can you use order by when defining a view?

0 Answers  

---

How do you read transaction logs

1 Answers  

---

---

Does table partitioning improve performance?

0 Answers  

---

What is Check point? Explain in Brief what it will do?

1 Answers   Wipro,

---

Can group by be used without aggregate functions?

0 Answers  

---

What is meant by indexing?

0 Answers  

---

What is the difference between count and distinct count?

0 Answers  

---

What is the maximum rows in sql server table?

0 Answers  

---

Your table has a large character field there are queries that use this field in their search clause what should you do?

0 Answers  

---