Answer / Shailaja Singh

An Execution Plan in SQL Server is a series of steps that the Query Optimizer generates to execute a Transact-SQL statement. It explains how the database engine intends to retrieve and manipulate data. To view the Execution Plan, you can use tools like SQL Server Management Studio (SSMS), using the 'Include Actual Execution Plan' option.

What do you understand by mirroring and mention the advantages of the mirroring?

1 Answers  

---

What is difference between joins and subqueries?

1 Answers  

---

What is ddl and dml commands?

1 Answers  

---

Can truncate be rolled back?

1 Answers  

---

write coding for importing sql data into a word excel...

1 Answers   Oracle,

---

How to apply filtering criteria at group level with the having clause in ms sql server?

1 Answers  

---

What is indexing explain it with an example?

1 Answers  

---

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

1 Answers  

---

Explain what is meant by replication of database?

1 Answers   Cap Gemini,

---

what is package configuration variable?How to change file name in folder dynamically?Plz help me

1 Answers  

---

HOW TO RENAME A COLUMN NAME

3 Answers  

---

Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.

1 Answers  

---