Answer Posted / suhail qaiser

select top 2 salary from emp order by salary desc

what data regions are and what are the different data regions?

146

---

What is tempdb database? : SQL Server Architecture

1258

---

How to truncate the log in sql server 2012? : sql server database administration

1346

---

What is a linked server in sql server?

1134

---

What is the difference between for auto and for nested?

1065

---

Explain Geometry datatype in sql server 2008 with example

1049

---

What is a fill factor?

1140

---

How many types of built in functions are there in sql server 2012?

969

---

How do I start sql server 2017?

986

---

Tell me the difference between clustered and non-clustered index?

991

---

Can another user execute your local temporary stored procedures?

1024

---

Explain how does the report manager work in ssrs?

999

---

Explain an incremental backup?

1052

---

Tell me what are the advantages of using stored procedures?

1062

---

What is difference between drop truncate and delete?

1154

---