Can you explain about buffer cash and log cache in sql server?

0 Answers  

---

Explain linked server in sql?

0 Answers  

---

How can you check the version of sql server?

0 Answers  

---

How do I start sql server agent automatically?

0 Answers  

---

Do you know what are acid properties of transaction?

0 Answers  

---

---

1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 Answers  

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

0 Answers  

---

what is the difference between table and view

1 Answers  

---

What is dbcc?

0 Answers  

---

In which files does sql server actually store data?

0 Answers  

---

Do you know the isolation level that sql server support?

0 Answers  

---

Which TCP/IP port does SQL Server run on?

2 Answers  

---