Viewing 15 posts - 3,376 through 3,390 (of 9,707 total)
Here's the UPDATE statement with the Key Lookup. To be honest, it isn't taking very long to run. My biggest issue is with another part of the query. Still, I'd...
September 20, 2013 at 6:17 am
GilaMonster (9/20/2013)
Is that plan with them being run together with other stuff, or them running separately?
Running together with GO between parts of the statement. I'm about to run the two...
September 20, 2013 at 6:06 am
Sean Pearce (9/20/2013)
SSMS doesn't like it when it has to print loads of messages.
Which would explain why it did it after I set Statistics Time and Stitistics IO on AND...
September 20, 2013 at 6:05 am
Make sure you have a good recovery plan (and lots of backups) in case the upgrade goes wrong. My laptop wasn't an issue because it was my personal sandbox and...
September 20, 2013 at 5:35 am
daniel.carreira (9/20/2013)
What happens if they are not in the same domain? Which seems to be the case!?
Then you have domain trust issues. Get with your domain admins and see what...
September 20, 2013 at 5:32 am
It's not doing it all the time, which is what confuses me. And now that I think about it, I did see this behavior with SQL 2005 and 2008 on...
September 20, 2013 at 5:29 am
L' Eomot Inversé (9/19/2013)
Brandie Tarvin (9/19/2013)
If you find one, let...
September 20, 2013 at 5:26 am
NTILE?
This is the first time I've heard of that one. Thanks, Micky.
September 20, 2013 at 5:25 am
Here we go. Tables & Indexes in the below code box. Execution Plan attached.
USE [MyDB]
GO
/****** Object: Table [dbo].[tblTransactionDetail] Script Date: 09/18/2013 07:54:20 ******/
IF EXISTS (SELECT...
September 20, 2013 at 5:14 am
GilaMonster (9/19/2013)
Execution plans please. Guessing otherwise.
I have to scrub the names first. I'll post it in a bit.
September 20, 2013 at 4:44 am
BTW, it's not a JOIN. It's an UPDATE on a single table that splits one column into many.
Basically it's:
UPDATE ri
SET col1 = Substring(ri.x), col2 = Substring(ri.x)....col7 = Substring(ri.x)
FROM MyTable ri
WHERE...
September 19, 2013 at 1:05 pm
Jack Corbett (9/19/2013)
Brandie Tarvin (9/19/2013)
Huh. Apparently the Key Lookup shook itself out of the execution plan a bit later on. Now I've got Clustered Index Scans.
Of course,...
September 19, 2013 at 12:59 pm
Okay, this is interesting. When I run the first two queries in conjuntion with everything else, the first execution plan changes back to a Key Lookup.
When I run them by...
September 19, 2013 at 12:58 pm
Thanks, Jack.
Huh. Apparently the Key Lookup shook itself out of the execution plan a bit later on. Now I've got Clustered Index Scans.
Of course, I've been playing with these table...
September 19, 2013 at 12:05 pm
Viewing 15 posts - 3,376 through 3,390 (of 9,707 total)