Answer Posted / naresh

8kb and if data(datatypes-varchar,varbinary) exceeds the
8kb row then proceeds to next page pointing with Pointers

Explain about protocol layer present in SQL server?

1188

---

What is a transaction and why is it important?

1079

---

What is the meaning of resultset type_scroll_insensitive?

948

---

What are various aggregate functions that are available?

971

---

How dts is used to extract, transform and consolidate data?

1067

---

Can you please differentiate between a primary key and a unique key?

1001

---

How to add more data to the testing table in ms sql server?

1073

---

State a few properties of relational databases?

1120

---

What is apply operator in sql?

1006

---

What is the difference between mysql and mysqli?

1182

---

What is change data capture (cdc) feature?

1050

---

Explain what is analysis service repository?

976

---

What is the difference between osql and query analyzer?

983

---

how to do partition in sqlserver

2457

---

How to view the error log for any specific instance? : sql server database administration

1025

---