Answer / Mithun Singh Rana

In SQL Server, Optimization refers to techniques and strategies used to enhance database performance and efficiency by improving query execution plans, reducing I/O operations, optimizing indexes, and more.

How do I create a partition table in sql server?

1 Answers  

---

What is the process of normalising?

1 Answers  

---

How to copy data from one table to another table?

1 Answers  

---

how to use DTS package in 2000,2005,2008 in sql server

1 Answers   Microsoft,

---

What are synonyms?

1 Answers  

---

Can the “if update (colname)” statement be used in a delete trigger?

1 Answers  

---

Why we use trigger in sql server with example?

1 Answers  

---

How to read 2nd highest sal from EMP table?

5 Answers   IBM, TCS,

---

What is difference statement and preparedstatement?

1 Answers  

---

where the connection string store in the database

1 Answers   HCL, Wipro,

---

A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

8 Answers   Infosys,

---

How do SQL server 2000 and XML linked?

2 Answers  

---