Viewing 15 posts - 3,406 through 3,420 (of 9,725 total)
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
My box doesn't have SSDs, so that's probably not it for me... Thanks for the info, though.
EDIT: I am using Windows 7 x64 (just got a new box) with SQL...
September 19, 2013 at 8:34 am
Koen Verbeeck (9/19/2013)
daniel.carreira (9/19/2013)
Hi Michal,So i have to add the user (databasename)/System to the sharedrive permissions, is it correct?
Best regards,
Daniel
Yes, it must have read/write access to the shared directory.
And if...
September 19, 2013 at 8:07 am
Speaking as someone who has upgraded a laptop from XP to 7 (both Pro versions, though), yes, it is possible.
As far as memory goes... That depends on the edition of...
September 19, 2013 at 8:04 am
I know half a dozen ways to do what you've requested. But any easier than the easiest way I posted above?
If you find one, let me know.
September 19, 2013 at 7:44 am
You can do this, but it's not simple.
You need a job with three steps, one for each type of backup. Then you need a schedule that will run (at minimum)...
September 19, 2013 at 7:41 am
Yes, you can sort out the middle. The easiest way to do it would be to create 2 temp tables. One for worst sellers, one for top sellers. Then join...
September 19, 2013 at 7:37 am
dwain.c (9/12/2013)
How does one go about organizing a SQL Saturday?
Anybody up for joining one in Bangkok?
I would coordinate through PASS. And contact Karla Landrum (@KarlaKay22 on Twitter). She's a SQL...
September 13, 2013 at 4:31 am
Jack Corbett (9/12/2013)
Brandie Tarvin (9/12/2013)
Go to http://www.sqlsaturday.com and see if there is a way to register for event notifications. That way if one pops up near you again,...
September 12, 2013 at 6:51 am
Viewing 15 posts - 3,406 through 3,420 (of 9,725 total)