Answer / Neha Sona

Advantages of partitioning in SQL Server include improved query performance, reduced I/O operations, easier data management, and better backup and recovery.

Explain the ways to controlling cursor behavior?

1 Answers  

---

What is #table in sql server?

1 Answers  

---

How to use wildcard characters in like operations in ms sql server?

1 Answers  

---

Psudo colums

1 Answers   HP,

---

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

1 Answers  

---

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1 Answers  

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

1 Answers  

---

What is bulkcopy in sql?

1 Answers  

---

How data can be copied from one table to another table?

1 Answers  

---

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

1 Answers  

---

How many types of objects are there?

1 Answers  

---

What is the ‘fillfactor’?

1 Answers  

---