Answer Posted / srao

select * from sysindexes

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1120

---

List out different types of normalizations in sql server and explain each of them?

935

---

Can I disable or restrict ssrs export formats (rendering formats)?

150

---

How dts is used to extract, transform and consolidate data?

1076

---

What are the restrictions that views have to follow? : SQL Server Architecture

1007

---

what is a correlated sub-query? : Sql server database administration

948

---

Explain use of expression builder.

1030

---

What happens if null values are involved in string operations?

996

---

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

1024

---

what is checksum in sql server.........???

1691

---

What is temporal data type?

925

---

Do you know data definition language, data control language and data manipulation language?

1045

---

Do you know the isolation level that sql server support?

965

---

Explain trigger classes i.e. Instead of and after trigger?

883

---

Explain what is lock escalation and what is its purpose?

932

---