Explain sp_configure commands, set commands?

3 Answers  

---

when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 Answers  

---

if no size is defined while creating the database, what size will the database have? : Sql server administration

0 Answers  

---

What is exclusive locks?

0 Answers  

---

Can you explain the role of each service?

1 Answers  

---

---

What are extended events in sql server?

0 Answers  

---

How to disconnect from a sql server using mssql_close()?

0 Answers  

---

What is table-valued sub query?

0 Answers  

---

Name 3 ways to get an accurate count of the number of records in a table?

0 Answers  

---

What is row_number function?

0 Answers  

---

can you any body tell me the difference between candidate key and primary key

4 Answers  

---

Describe in brief databases and sql server databases architecture.

0 Answers  

---