Viewing 15 posts - 3,376 through 3,390 (of 9,703 total)
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
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
Viewing 15 posts - 3,376 through 3,390 (of 9,703 total)