Answer Posted / amit

select distinct * from table_name

What is an execution plan? When would you use it?

1026

---

How can we get count of the number of records in a table?

996

---

Explain the steps to create and execute a user-defined function in the sql server?

1016

---

How to drop an existing table with "drop table" statements in ms sql server?

1147

---

How to skip remaining statements in a loop block using continue statements?

1041

---

what is spatial nonclustered index

1036

---

Tell about MOM Tool(Microsoft Operator Manager)?

1959

---

What is the difference between implicit and explicit transaction?

1052

---

When is update_statistics command used?

1087

---

Define msdb database?

1077

---

Is it important for a database administrator to understand the operating system and file access?

1041

---

Explain what are the basic functions for master, msdb, model, tempdb databases?

1029

---

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

1307

---

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1036

---

What command is used to delete a table from the database in the sql server and how?

1187

---