Answer Posted / hari

Management Studio
DMV
CLR Interegation
Database mirroring

What is difference between Datepart() and Datename() in SqlServer?

728

---

What is database isolation in sql server? : sql server database administration

571

---

when would you go for denormalization? : Sql server database administration

489

---

Why use identity in sql server?

568

---

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

525

---

---

How to insert data with null values?

596

---

What is normalization and denormalization in sql server?

543

---

Is sql different from sql server?

519

---

Do you know what are the ways available in sql server to execute sql statements?

547

---

Define outer join?

540

---

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

116

---

How does a profiler work?

521

---

What is the use of tempdb? What values does it hold?

573

---

How can we determine what objects a user-defined function depends upon?

524

---

How do we know if any query is retrieving a large amount of data or very little data?

559

---