Nice question, answers were hard to read, but in the end I got my point.

"El" Jerry.

InaGaddaDaVida.

"El" Jerry.

bitbucket-25253 (5/31/2012)

Cliff Jones (5/31/2012)

+1 but like Tom I was...

Thank you for the question, Ron.

I also got the right answers by elimination of the first 2 false statements.

"El" Jerry.

Ron, thank you for the easy question.

roger.plowman (5/30/2012)

You know, if you took out the transaction the answer would be exactly the same? How then is this a transaction? 🙂

Still say...

Good question, better discussion. I agree both the question and the answer would've been better worded, so let me add my $0.02 here.

The question says "Which of the following system...

Great question. I had not worked with REFERENCES before, but learned something new today.

Have a great weekend everyone!!

"El" Jerry.

I have used BCP before in several situations and have found it works lightning fast compared to other solutions. You may want to take a look at these documents:

BCP utility

http://msdn.microsoft.com/en-us/library/ms162802.aspx

Creating...

I find it strange that this output is sent...

Blindfolded.

50/50

Good question, had to research a little to get it right.

Have a great weekend!!

"El" Jerry.

Interesting question, learned something new today, but it is weird I got the right answer from this page (Sparse Columns Support for OLEDB):

http://msdn.microsoft.com/en-us/library/cc280446(v=sql.100).aspx

I agree the wording could've been better, both...

Carmack? As in John?

Great question, made me think a little bit. Good to know the details on comparisons between different data types.

"El" Jerry.