Write an sql query to find first weekday of the month?

0 Answers  

---

How to Insert multiple rows with a single insert statement?

0 Answers  

---

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

0 Answers  

---

What is the concept of optimization?

0 Answers  

---

How can a user-defined datatype be created?

0 Answers  

---

---

Does partitioning improve performance?

0 Answers  

---

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

0 Answers  

---

Which tcp/ip port does the sql server run on? How can it be changed?

0 Answers  

---

What’s the distinction between dropping a info and taking a info offline?

0 Answers  

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,

---

What is scalar user-defined function?

0 Answers  

---

What are triggers in ms sql server?

0 Answers  

---