As someone stated earlier, the link apparently is incorrect since it doesn't enforce the minimum scale you describe here although we're obviously seeing it. I left feedback on the link...

select cast(1.67574 as decimal(38,10)) = 1.675400000 which has precision 6 and scale 10, right?

and

select cast(10000 as decimal(38,10)) = 10000.0000000000 which has precision 1 and scale 10, right?

So,

[font="Courier New"]p1 - s1...

If the SELECT statements had been formulated to indicate the time zone (e.g., 2009-11-16 08:01:18.177 CST, 2009-11-16 14:01:18.177 GMT), then what you are saying would be correct. A person viewing...

Good question. I got it wrong but I learned something. Thanks!

Steve,

I find it very sad that your description of Memorial Day, "something that celebrates the start of warm weather and time off," is all that Memorial Day means to most...

I highly recommend Fireproof. It just came out on DVD.

I also enjoyed Kung Fu Panda (more than Wall-E, personally) for watching with the kids.

And I will echo that I wasn't...

Well, Steve, it's your fault I didn't get much sleep last night. Based on your recommendation, I requested The Broken Window from my public library back in September when you...

I didn't select .ndf because it is a suggested name, not a default. A default implies that if the user makes no other selection, the system will automatically set a...

Well, not having Management Studio yet, I checked Microsoft's list of keyboard shortcuts for SQL Server at http://technet.microsoft.com/en-us/library/ms174205.aspx. There is no sp_help listed on the page at all,...

I got the question right, but actually the answer is not correct. Since the question asked, what does "PRINT MIN_ACTIVE_ROWVERSION()" return, the answer is (from Books Online) "Returns a user-defined...

Speaking of winning the book, does SQL ServerCentral ever announce who the winners are in these contests? It'd be nice to see in the daily email.

Arrgh, Randy Quaid, not Dennis!

I don't think Steve is going to give us our points back. I'm not even sure if he's aware that we are all complaining about the second incorrect answer to...

We want our points back, we want our points back...

No points, no peace!

Several of the examples were unreadable, displaying only a horizontal scroll bar. What might have been the example code was in a window which appeared to be 1 or 2...