Answer Posted / krishna

int data type

What is acid properties?

790

---

What is the fillfactor concept in indexes?

738

---

What is SubQuery in SQL Server 2008

731

---

What is faster join or union?

814

---

Can you pass expressions to stored procedure parameters?

721

---

What is the openxml statement in sql server?

756

---

What does it mean to be in union?

688

---

What is single-user mode?

709

---

Is it safe to delete log files?

680

---

What is sharding?

103

---

What is normalization? Explain its different types?

806

---

What are window functions in sql server?

702

---

How do you delete a data source?

765

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

650

---

Define left outer join in sql server joins?

719

---