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.

if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?

2 Answers  

---

Explain about the command-line tool SQLCMD?

0 Answers  

---

How many types of subqueries are there in sql server?

0 Answers  

---

Tell me about normalization in DBMS.

0 Answers   Honeywell, Zomato,

---

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 Answers  

---

Explain what are page splits? : SQL Server Architecture

0 Answers  

---

Define right outer join in sql server joins?

0 Answers  

---

What is default port number for sql server 2000?

0 Answers  

---

What is bit datatype and what's the information that can be stored inside a bit column?

1 Answers  

---

What is the difference between insensitive and scroll cursor?

0 Answers  

---

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

1 Answers  

---

What is the difference between functions and stored procedures?

0 Answers   Accenture,

---