Answer / Rehan Ahmad

SQL Server Replication is a feature that allows data to be shared between multiple databases, either on the same server or different servers. It provides a way to distribute and keep data in sync across various environments.

Explain the phases a transaction has to undergo?

1 Answers  

---

What is the fillfactor concept in indexes?

1 Answers  

---

Explain what are page splits? : SQL Server Architecture

1 Answers  

---

What is fill factor and pad index?

1 Answers  

---

What do you mean by recursive stored procedure?

1 Answers  

---

Differencr Between DELETE and TRUNCATE?

3 Answers   ADP,

---

How and why use sql server?

1 Answers  

---

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1 Answers  

---

What is Self Join?

4 Answers  

---

Can the query output be sorted by multiple columns in ms sql server?

1 Answers  

---

What is the role that is required for killing a process What is the role that is required for creating a linked server

1 Answers   CarrizalSoft Technologies, IBM,

---

What’s the use of custom fields in report?

1 Answers  

---