Do you know sql server 2008 introduces automatic auditing?

0 Answers  

---

Explain what are db_options used for?

1 Answers   InterGraph,

---

what is create database syntax? : Sql server database administration

0 Answers  

---

What are statistics, under what circumstances they go out of date, how do you update them?

2 Answers   HCL,

---

Can I work with several databases simultaneously? : sql server management studio

0 Answers  

---

Which are the olap features?

0 Answers  

---

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

0 Answers   IBM,

---

What is difference between index seek vs. Index scan?

0 Answers  

---

Can we store videos inside the sql server table?

0 Answers  

---

Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

2 Answers   Techno Solutions,

---

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

0 Answers  

---

Define self join in sql server joins?

0 Answers  

---