Answer Posted / 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

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

1065

---

What are the benefits of filtered indexes?

1093

---

What is sql server agent and what are the two modes of authentication in sql server?

1107

---

How to execute stored procedure and set temp table in sql server?

1088

---

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1095

---

What are secondary xml indexes?

1072

---

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

1253

---

In what version of sql server were synonyms released?

993

---

How to invoke a trigger on demand?

1145

---

What is pessimistic concurrency?

1021

---

What happens if null values are involved in arithmetic operations?

1041

---

What is the default schema of your login session in ms sql server?

1086

---

Explain the categories of stored procedure?

977

---

Mention the differences between local and global temporary tables.

1105

---

What is a periodical index?

971

---