You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

0 Answers  

---

sql server syntax to add "!" sign to "name" field of "employee" table in a manner that all names have the same lenght of 20 characters

1 Answers  

---

What is a full text index?

0 Answers  

---

What is a job?

3 Answers  

---

What are types of storage modes? : sql server analysis services, ssas

0 Answers  

---

---

is it important for a database administrator to understand the operating system and file access? : Sql server administration

0 Answers  

---

What is buffer cash and log cache in sql server?

0 Answers  

---

What is a data collection table?

0 Answers  

---

Explain having clause and where clause?

0 Answers  

---

Does group by or order by come first?

0 Answers  

---

What is apply operator in sql?

0 Answers  

---

What are the type of joins? When do we use Outer and Self joins?

3 Answers  

---