Answer Posted / asha

Null

How can you append an identity column to a temporary table?

1076

---

How do I start sql server 2017?

1023

---

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

1047

---

Where can you add custom error messages to sql server?

1220

---

How do I find the sql server version?

1114

---

What is in place upgrade in sql server?

1137

---

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1031

---

Disadvantages of the indexes?

1230

---

What is a coalesce function?

1292

---

When should you use an instead of trigger?

1061

---

How do I create a trace in sql server?

1126

---

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1051

---

Does view occupy space?

1031

---

Why we use the openxml clause?

1088

---

what is spatial nonclustered index

1066

---