Good question.

A lot of careless readers around today - 31% (about 80) so far have picked 0, and I suspect the number of those who picked that for some other...

Lynn Pettis (8/13/2012)

---

I have to ask you what your definition of visible surrogate key is? Are you talking visible to the application or visible to the user of the...

Is that an acronym for the Metadata Encoding and Transmission Standard, or did you mean those people in New York who play a funny sort...

Matt Miller (#4) (8/13/2012)

---

Jeff Moden (8/11/2012)

---

L' Eomot Inversé (8/11/2012)

---

I wouldn't claim that the problem can be avoided, simply that it is just as serious with (application-visible) surrogate keys as with...

Wood alcohol

Scott D. Jacobson (8/12/2012)

---

This kind of thing:

http://www.sqlservercentral.com/Forums/Topic1343859-1292-1.aspx

Where in the world are these jobs where someone can get hired with 0 experience in the position? I don't think that kids fresh...

With no previous database experience you should maybe expect your employer to provide some training.

However, there are some reasonable tutorials available online. But learning to handle BI related products...

Nice question.

Looking at the incorrect options I makes me wonder if the topic should have been "humour" instead of "XML"

Steve Jones - SSC Editor (8/2/2005)

---

What everyone has presented is valid. However the question wasn't "how do I solve this", it was a "identify the problem". tempdb being shared is...

"Recover" is maybe a bit inaccurate when used to refer to reverting to a snapshot.

sswords (8/19/2005)

---

Interesting wording on the answers.

At the time the snapshot is taken, the schema and data for all objects is stored in the snapshot folder. Does this not constitute a...

Jamie Thomson (9/23/2005)

---

Yelena,

Its an interesting point. Its obvious that the use of the terms "synchronous" & "asynchronous" mean something different in an SSIS context than they do in a programming...

SQLRNNR (12/9/2009)

---

I agree with the previous post on this one. The default for Reporting Services 2000 was for pageheight to be in Inches and the height would have been...

Some irritating labelling by MS there.

Since on SQL 2000 at one point I backed up MSDB very often (there were lots of jobs running on my servers, so...

Scott Beckstead (10/20/2005)

---

synchronous, asynchronous...

I was expecting something related to time. An asynchronous process is one that is not timed to a particular event. A synchronous process is locked to...