Viewing 15 posts - 3,601 through 3,615 (of 5,678 total)
I reformatted this to use aliasing and cleaned up the where clause to reduce repetitive logic and try to clean up the parenthentic pathing. Hopefully it'll help others 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
March 23, 2011 at 4:50 pm
Grant Fritchey (3/23/2011)
As long as you're running this function on the column, you're guaranteed table scans: CONVERT(char(10), dbo.Notes.FollowUp, 111)
Unfortunately, as does this:
AND (NOT (dbo.[Active Patients].Status LIKE N'%0 - In House%'))
There's...
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
March 23, 2011 at 4:30 pm
Your tempdb is suiciding, it doesn't have enough room to grow large enough for whatever subtables the plan has decided it needed. My guess is because of the Distinct...
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
March 23, 2011 at 4:25 pm
GilaMonster (3/23/2011)
Jan Van der Eecken (3/23/2011)Craig, 'Inventing a Lane' did not originate in Boston, it was first registered as a purely South African invention. Our "communal" taxis (can't call them...
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
March 23, 2011 at 4:24 pm
mtillman-921105 (3/23/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
March 23, 2011 at 4:22 pm
opc.three (3/23/2011)
Another technique I have found useful is to use the EXEC...AT expression because it let's you use a variable and you can still pipe the results into...
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
March 23, 2011 at 4:20 pm
suri.yalamanchili (3/23/2011)
I understand the metrics would be different for both the instances (OLTP vs OLAP)
Is there a range of good metrics for OLTP is what I trying...
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
March 23, 2011 at 3:27 pm
I'm with Grant, 2000 rows is relatively tiny.
Got LOB data in this? Is the data stored on your local hard-drive or a server? How long is 'long' -...
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
March 23, 2011 at 2:45 pm
You might run this first:
(SELECT CONVERT(varchar(10), MAX(ACCOUNTING_DATE), 101) AS Expr1
FROM DB1.dbo.Table2
WHERE ACCOUNTING_DATE <= GETDATE())
And drop that to a variable since you're not using any row-level interaction.
You've gone through 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
March 23, 2011 at 2:41 pm
Hm, an anthology of sci-fi and fantasy hookers. Anyone else have that list of books to read that just gets longer... and longer... and longer...? 😀
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
March 23, 2011 at 12:10 pm
Jimble,
Is this everything? The final component of the graph looks like it's a 3 way deadlocking but only spids 67 and 84 have descriptions above, and 60 seems like...
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
March 23, 2011 at 12:05 pm
Steve Jones - SSC Editor (3/23/2011)
Looks like everyone behaved while I was out yesterday. Good job, everyone
Errr, crap, you're back fast. Back in a bit, I've got some mass...
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
March 23, 2011 at 11:47 am
Jack Corbett (3/23/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
March 23, 2011 at 10:59 am
Brandie Tarvin (3/22/2011)
Oh, hey, completely non-SQL related link:If you like superheroes, you will like "Grayson" (They created this trailer with an 18,000 dollar budget).
Holy Crap... that's like 10 hours 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
March 23, 2011 at 3:07 am
I'm on the fence on catch-all queries, and yes, I know the optimizer problems. It doesn't mean I like dynamic SQL in general.
I have a simple rule when 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
March 22, 2011 at 6:30 pm
Viewing 15 posts - 3,601 through 3,615 (of 5,678 total)