What do you mean by sql server agent?

0 Answers  

---

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

0 Answers  

---

you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

0 Answers  

---

How to create an index on an existing table in ms sql server?

0 Answers  

---

What are the different types of queries?

1 Answers  

---

---

Explain having clause and where clause?

0 Answers  

---

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  

---

What is the difference between a fill factor of 100 and 0?

0 Answers  

---

Explain datetime2 data type in sal server 2008?

0 Answers  

---

What is difference between getdate and sysdatetime in sql server 2008?

0 Answers  

---

What are basics of policy management?

0 Answers  

---

What does it mean to have quoted_identifier on? What are the implications of having it off?

2 Answers  

---