Can a database be shrunk to 0 bytes, if not, why?

1100

---

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?

1119

---

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1019

---

Why should one not prefix user stored procedures with ‘sp_’?

1042

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

992

---

What are the new data types are introduced in sql 2000?

899

---

List some of the rules that apply to creating and using a ‘view’

886

---

Explain active/passive and active/active cluster configurations?

1057

---

Can a database be shrunk with users active?

1127

---

How you can change a cross join into an inner join?

962

---

How you can add messages to the nt event log from within a stored procedure?

1064

---

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

1064

---

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

1005

---

Can a rule be bound to any column of any data type?

959

---

can an order by clause be used in a creation of a view?

1174

---