Viewing 15 posts - 5,131 through 5,145 (of 5,678 total)
Why does oldLocal have 16.00 and a real datetime value in it? Barring the rest, what are the non datetime values supposed to mean? You're overloading the column,...
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
November 1, 2010 at 5:33 pm
mymail.default (11/1/2010)
I will do it now, but just to make sure I understand:
This change is going to go on the test system right, and being executed on the test system...
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
November 1, 2010 at 4:55 pm
SwedishOrr (11/1/2010)
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
November 1, 2010 at 4:51 pm
SQL33 (11/1/2010)
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
November 1, 2010 at 4:40 pm
Each message in the queue is supposed to be either unique, or your procs are supposed to deal with them in conversations. So, each of the queue's only deals...
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
November 1, 2010 at 4:35 pm
Sorry for the slight necro, was a heck of a 2 weeks and catching up on some older stuff.
Jeff Moden (10/16/2010)
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
November 1, 2010 at 4:19 pm
Naidu,
Let's figure a few things out here. First, if you could take a look at the first link in my signature, and setup DDL and sample data that way,...
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
November 1, 2010 at 3:31 pm
It will seek when selectivity makes sense for it. Now, can you give us more context of if this is the same proc/query on both servers? You might...
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
November 1, 2010 at 3:09 pm
Try this:
Be aware, this uses a serial updating methodology and I don't always follow every rule from Jeff's Quirky Update post here on SSC. This will work, however, as...
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
November 1, 2010 at 3:04 pm
Something like this, perhaps?
SELECT
Code,
MaxTime,
CASE WHEN CODE = 'XX' AND MaxTime >= '2010-10-02' THEN 'DELAY'
WHEN CODE = 'XY' AND MaxTime >= '2010-10-05' THEN 'DELAY'
ELSE 'SUCCESS' END AS SuccessDelay
FROM
(SELECT
Code,
MAX( [Time]) AS MaxTime
FROM
#Temp...
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
November 1, 2010 at 2:53 pm
Problem is this portion of your query, in regards to the error:
(select ("timestamp") from X where refeventid=b.refeventid
and "timestamp"< b."timestamp")
It needs to return a single entry for the function, 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
November 1, 2010 at 2:49 pm
James, thank you for the kindness. It's appreciated... especially recently.
Hahah, okay, now that the selectivity is frying the 0.3% rule (1 day in a year, as a rule of...
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
November 1, 2010 at 2:41 pm
An alternative is going to be a #tmp with specific indexes using the Quirky Update method, inverting the row numbering, using quirky to carry values down the nulls, then inverting...
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
November 1, 2010 at 2:02 pm
WayneS (11/1/2010)
Craig, I guess you whopped up on me! Only 40% of the time of mine... very good.
Well, every now and then I get lucky. :w00t: Honestly though, my...
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
November 1, 2010 at 1:51 pm
Were you able to try this in a copy of the proc?
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
I'm curious if we can completely absolve the system of the locking issue.
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
November 1, 2010 at 1:24 pm
Viewing 15 posts - 5,131 through 5,145 (of 5,678 total)