Answer Posted / brajesh kumar srivastava

Clustered index

What are the various editions of sql server 2017 that are available in the market?

892

---

How do I create a stored procedure in dbml?

1009

---

What do you understand by the denormalisation?

957

---

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1075

---

How to select all columns of all rows from a table with a select statement in ms sql server?

1114

---

What is field with example?

923

---

What is the main difference between ‘between’ and ‘in’ condition operators?

1191

---

What is a natural primary key?

1044

---

Why use “nolock” in sql server?

1058

---

Tell me what is use of except clause? How it differs from not in clause?

962

---

Tell me what is a linked server?

1040

---

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

977

---

Explain how to integrate the ssrs reports in application?

1017

---

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

169

---

Do you know what are pages and extents? : SQL Server Architecture

995

---