Viewing 15 posts - 106 through 120 (of 200 total)
Jeff Moden (5/31/2011)
Craig Farrell (5/31/2011)
Jeff Moden (5/31/2011)
The Dixie Flatline (5/31/2011)
Could 42 possibly be the airspeed velocity of an unladen swallow?
Nope... it's the terminal velocity for a pork chop with a...
June 1, 2011 at 1:17 am
Not sure if this is still an issue, and it's late for me. Both of those are reasons I shouldn't post code. 😛
It occurs to be that a...
May 12, 2011 at 2:38 am
Steve Jones - SSC Editor (5/3/2011)
May 5, 2011 at 2:07 am
jcrawf02 (5/2/2011)
Stefan Krzywicki (5/2/2011)
Fal (5/2/2011)
Stefan Krzywicki (5/2/2011)
Fal (5/1/2011)
May 2, 2011 at 8:49 pm
Stefan Krzywicki (5/2/2011)
Fal (5/1/2011)
May 2, 2011 at 5:00 pm
After a horror week in which half my mirrors crashed, a royal wedding saturated the TV, radio, newspapers (as well as my dreams after a derriere walked up the aisle)...
May 1, 2011 at 9:11 pm
Yes, I was somewhat thrown when it was suggested that TempDB would be redundant if there was enough RAM. Problem is that the vendor concerned is, well, prestigious enough...
April 28, 2011 at 7:01 am
Brandie Tarvin (4/26/2011)
Flipping the variable to Object, testing the task with Decimal and Float, flipping both task and variable back to Double...
And the X#*@#!...
April 27, 2011 at 9:27 pm
Thanks for the article. My only suggestion is that I think you might have made a stronger point by using 'hour' for your DATEDIFF examples as timezone differences are...
April 18, 2011 at 9:17 pm
alen teplitsky (4/18/2011)
a lot of the listings are fake and are just head hunters looking for resumes for their database
Ah, now there's something I've also noticed: the same job...
April 18, 2011 at 8:20 pm
Consider this, though you would need to confirm that the @Val1 is in fact the prefix of @Val2:
declare@Val1varchar(50)
, @Val2varchar(50)
select@Val1 = 'G1.EngCoolTemp'
, @Val2 = 'G1.EngCoolTemp.C1.GenLoCoolT'
selectsubstring(@Val2, len(@Val1)+2, 50)
Steve.
April 17, 2011 at 8:36 pm
Thanks for the article - it's always good to get opinions like this.
Sadly, you left out the old Bait n Switch. This happened to me a few years ago...
April 15, 2011 at 1:55 am
sandro977 (4/11/2011)
... because in a Function you can't use a temporal table to reduce the universe, and this is something very important...
For that you need: DBCC SHRINKUNIVERSE 😛
sandro977 (4/11/2011)[hrBy...
April 11, 2011 at 9:37 pm
Craig Farrell (4/4/2011)
Steve Jones - SSC Editor (4/4/2011)
April 4, 2011 at 9:32 pm
Hmmm. Not sure you're quite there yet. What you have gives you:
CFS-20110401-008
CFS-20110401-009
CFS-20110401-0010
CFS-20110401-0011
CFS-20110401-0012
So, if every number you enter needs to be prefixed with '00' then ignore this comment, otherwise...
April 4, 2011 at 7:30 pm
Viewing 15 posts - 106 through 120 (of 200 total)