That comma does not generate any...

Richard Warr (5/11/2011)

---

A question that enables most people to get the correct answer after some careful thought is by no means "too simple". Especially as over 1/3 of respondants have...

Good easy question, but I do not agree with the answers explination.

A unique constraint is what a table needs to garuntee an column does not repeat values.

Making a column part...

Peter Trast (5/9/2011)

---

We have had alot of really good questions the last few weeks, although I am not sure if questions that DON'T start a debate are really so great...

Steve Jones - SSC Editor (5/9/2011)

---

John Mitchell-245523 (5/9/2011)

---

I discounted Page splits/sec because page splits are also caused by INSERT statements, and therefore if you wanted to measure the rate at...

Paul Randal (5/6/2011)

---

There's no choice but to have it behave that way because something in the transaction log that gets recovered at the end of the restore good disable compression...

jadsmith (5/6/2011)

---

It would depend on if the database backed up contains Enterprise features or not. If not the backup should restore with no problems. The question doesn't say that there...

I do not know if PSN is considered true "cloud".

It affected 25 million SOE users for over 14 days, and who knows the count of users that where unable to...

Nice article on how to save you self with single user mode.

As has already been menationed know to use the -f switch is a question every DBA should ready for...

I felt the same way, but knew the answer was 4.

I...

Ninja - If the reports running these mystery querries are Crystal Reports or Business Objects Reports you are in for some fun.

I worked in a large environment that...

Wow....

I thought this was a real easy question until I saw the results.

I saw a lot of people asking if this is used a lot in the real world.

My Answer:

In...

Peter Trast (4/28/2011)

---

I am fairly sure that some of the calculations in the article http://www.sqlservercentral.com/articles/Resource+Governor/64034/ are incorrect. When calculating the Effective MAX for a pool you do NOT include the...

Chris Umbaugh (4/28/2011)

---

When attempting to learn the effective max% concept I read the following SQLServer Central article which I find misleading (at least as I interpreted it): http://www.sqlservercentral.com/articles/Resource+Governor/64034/

It...

Obs (4/28/2011)

---

Well played!

Slope (4/27/2011)

---

Of course, if you use a calendars table you never have to worry about having to code or validate any date calculations ever again. 😛 Sure...