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.

Explain candidate key, alternate key, and composite key?

0 Answers  

---

What is a transactions?

0 Answers  

---

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

---

Is it possible to create tables in stored procedures using a variable for the table name?

2 Answers  

---

How to select nth record from a table?

13 Answers   DELL, Microsoft, Ramco,

---

---

Differentiate between ms sql server reporting services vs crystal reports?

0 Answers  

---

what operator performs pattern matching?

2 Answers  

---

Explain database normalization?

0 Answers  

---

How to use union to merge outputs from two queries together in ms sql server?

0 Answers  

---

What does Master database contains?

0 Answers   Abacus,

---

What are the differences between stored procedure and the dynamic sql?

0 Answers  

---

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---