Answer Posted / shraddha

sp_tables

Is it possible to have clustered index on separate drive from original table location?

1039

---

Can sql servers link to other servers like oracle?

915

---

How raid can influence database performance?

1116

---

Why use identity in sql server?

1196

---

Can we do dml on views?

1035

---

How do I start sql server 2017?

1015

---

What is the difference between upgrade and migration in sql server?

1183

---

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1068

---

Explain “row_number()” in sql server with an example?

1076

---

What are wait types?

1248

---

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1298

---

what is spatial nonclustered index

1057

---

How to rebuild the master database?

1163

---

What is in place upgrade in sql server?

1125

---

What is standby servers? Explain types of standby servers.

1078

---