Answer Posted / anil

delete from tab_nam where

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?

1037

---

Can one drop a column from a table?

1075

---

List the ways in which dynamic sql can be executed?

1074

---

How to rebuild the master database?

1150

---

do you know how to configure db2 side of the application? : Sql server database administration

1110

---

What are the different subsets of sql?

1635

---

What is a scheduled job or what is a scheduled task?

1027

---

How can I check that whether automatic statistic update is enabled or not?

1104

---

What are different types of constraints?

985

---

What is clustered index

1079

---

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

1062

---

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1118

---

Can you index views?

951

---

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1202

---

How to enter binary string literals in ms sql server?

1231

---