Viewing 15 posts - 5,296 through 5,310 (of 7,483 total)
Greg Edwards-268690 (10/20/2011)
Ninja's_RGR'us (10/19/2011)
Fal (10/19/2011)
Steve Jones - SSC Editor (10/19/2011)
Nooooooooooooooooooooooooooooooooooo more pantsOkay people, you heard the guy. No more mentioning the word "pants". Got it?
Steve.
As if that ever...
Tom
October 20, 2011 at 12:27 pm
Ninja's_RGR'us (10/19/2011)
I can't believe this hasn't come up yet.PANTS. 😀
Maybe they've gone down instead? After all, they are nearer tites than mites.
Tom
October 20, 2011 at 12:19 pm
Cliff Jones (10/20/2011)
SQLRNNR (10/20/2011)
Had to guess what the third correct answer was. Assumed option 5 meant cannot and was lucky.
Yes, it seemed the most likely so I made the...
Tom
October 20, 2011 at 12:14 pm
vk-kirov (10/19/2011)
Resource Governor Concepts
Tom
October 20, 2011 at 12:10 pm
If pants be the food of love play on...
Tom
October 18, 2011 at 5:02 pm
Rich Weissler (10/18/2011)
L' Eomot Inversé (10/18/2011)If the source precisions add up to 37 or less, the scale is the sum of the source scales; otherwise it is 6. At...
Tom
October 18, 2011 at 3:58 pm
Rich Weissler (10/18/2011)
Tom
October 18, 2011 at 9:08 am
SQLRNNR (10/18/2011)
CoolCodeShare (10/18/2011)
Guys,do you think for the examples given in this question, min(s1+s2,37-(p1+p2)) is the reduction policy as Tom suggests.
SQLRNNR can you clarify Tom's point?
That is the policy...
Tom
October 18, 2011 at 9:02 am
SQLRNNR (10/18/2011)
I largely agree. And it is these little things that cause so many trip-ups. I wrote about it once upon a time[/url].
Nice blog entry.
Had I seen it...
Tom
October 18, 2011 at 5:21 am
Good interesting question.
Just shows what bizarre and ridiculous results you can get because of the decision not to attempt accuracy with "exact" numerics.
Try it with DECLARE @a decimal(38,33) (or...
Tom
October 18, 2011 at 4:06 am
Revenant (10/17/2011)
Dude63 (10/17/2011)
nwerner (10/17/2011)
EBCDICMainframe
Big Blue
Customer control tactic?
Extraordinarily Bad Coding Designed to Imprison Customers
Tom
October 17, 2011 at 11:45 am
As Cindy and Gail have said, SQL Server resolves deadlock and kills off one of the transactions involved. You can get error log records about this bty setting trace...
Tom
October 17, 2011 at 4:21 am
ruan.keyser (10/14/2011)
I don't necessarily think this is an issue with the IO,
I am currently busy monitoring the following Counters in Perfmon:
Avg....
Tom
October 17, 2011 at 2:43 am
Very good question
I shouldn't try to think this early!
Tom
October 17, 2011 at 1:49 am
Viewing 15 posts - 5,296 through 5,310 (of 7,483 total)