Viewing 15 posts - 3,601 through 3,615 (of 5,685 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...
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...
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...
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...
March 23, 2011 at 4:24 pm
mtillman-921105 (3/23/2011)
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...
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...
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' -...
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...
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...? 😀
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...
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...
March 23, 2011 at 11:47 am
Jack Corbett (3/23/2011)
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...
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...
March 22, 2011 at 6:30 pm
Viewing 15 posts - 3,601 through 3,615 (of 5,685 total)