Viewing 15 posts - 2,161 through 2,175 (of 5,685 total)
I'm kind of surprised your max version with that code isn't 2.3.0.18.
However, it's varchar(). You shouldn't be running into a serious problem ... YET. Not until you're dealing...
December 5, 2011 at 11:08 am
ted_oconnor (12/5/2011)
My concern is this: How do I link the two pseudo tables Inserted and Deleted when checking for changes?
You can't. This is why you need to...
December 5, 2011 at 10:54 am
MathewK (12/2/2011)
That was awesome!!
i was running around in circles trying to use the While loops and getting no where. The Tally helps, with a little tweaking to the code...
December 5, 2011 at 10:15 am
Jeff Moden (12/3/2011)
Evil Kraig F (12/1/2011)
Ugh, nasty. You need a row-repeater. Which means... To the TALLY!
BWAAA-HAAA!!!! Beer popsicles... Dust Bunnies... nicely done Tally Table solutions... and a...
December 5, 2011 at 10:14 am
Steve Jones - SSC Editor (12/5/2011)
Evil Kraig F (12/5/2011)
For Express because of laptops? That seems a stretch to me.
Does the inclusion/use of TDE on Express preclude or interfere with...
December 5, 2011 at 10:09 am
Charmer,
how are you dealing with concurrency concerns here, IE: Two people are doing the same thing at once, both receive the value (for example) 00004081, and they both try to...
December 5, 2011 at 9:57 am
Dev (12/5/2011)
But a much better approach would be using the COLUMNS_UPDATED function.
It requires bit comparison. If OP is comfortable with it, GO Ahead. I usually avoid it...
December 5, 2011 at 9:56 am
MasterDB (12/5/2011)
if i execute the procedure manually it is dequeuing, but it is not dequeuing automatically from that procedure..
Sounds like the activation procedure isn't set or is running under a...
December 5, 2011 at 9:50 am
Jeffrey Irish (12/5/2011)
I have not received overtime for a very, very long time while I routinely work 55 to 70 hours per week, depending.
Last job I had like that I...
December 5, 2011 at 9:49 am
I'm going to have to disagree here. Once of the direct concerns for TDE is the separation of data and hosting instance. In a scenario for laptops and...
December 5, 2011 at 9:41 am
wesley.boyd (12/5/2011)
Ive set this up in its own MyAppServiceBrokerDB and it works fine for local stored procs.
How do i execute sp's in a different database? (both...
December 5, 2011 at 9:36 am
Ninja's_RGR'us (12/2/2011)
GSquared (12/2/2011)
Ninja's_RGR'us (12/2/2011)
Happy putzy week-end (I hope I got the meaning right!).
Definition 1: unintelligent person: somebody regarded as very unintelligent and unpleasant
But I was just quoting Blazing Saddles because...
December 2, 2011 at 11:46 am
Barkingdog (12/2/2011)
December 2, 2011 at 11:42 am
Divine Flame (12/2/2011)
Not able to view the plan attached. May be you need to attach it again.
Sorry, had to comment. L, awesome avatar. 🙂
December 2, 2011 at 2:47 am
nico van niekerk (12/1/2011)
I'd like to delve deeper into your observations before I update the statistics thereby destroying this particular scenario. Earlier I did pull FileSummaries into a...
December 1, 2011 at 6:46 pm
Viewing 15 posts - 2,161 through 2,175 (of 5,685 total)