Viewing 15 posts - 2,161 through 2,175 (of 5,678 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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 2, 2011 at 11:46 am
Barkingdog (12/2/2011)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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. 🙂
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 1, 2011 at 6:46 pm
Viewing 15 posts - 2,161 through 2,175 (of 5,678 total)