Viewing 15 posts - 12,286 through 12,300 (of 26,486 total)
Must be a language thing because you are missing the my point. Your data warehouse needs to capture that information that you are missing from your aggregate fact tables....
May 2, 2012 at 7:03 am
Really?? OMG. Now we have someone that can't even do simple math. :sick:
May 2, 2012 at 6:54 am
Krasavita (5/2/2012)
Thank you everyone, but article recomends 6GB set to 4800, how did you come up with that number 4096 and plus 2 gb.Thank you
Simple math. Start with...
May 2, 2012 at 6:51 am
ppcentral (5/2/2012)
@Lynn
,You're always answering with a question... and my question is simple and objective.
Thank you both for yoru kindly replies.
Pedro
No, I'm not always answering with a question. But...
May 2, 2012 at 6:49 am
Cadavre (5/2/2012)
This is ugly, needs to be tidied up and requires some performance tuning. ...
May 2, 2012 at 6:41 am
Almost PARTY TIME. SSC is getting close to 1,500,000 members! Currently at 1,498,547 .
May 1, 2012 at 9:21 pm
First, we are all volunteers here, giving of our own time. If you have not gotten an answer it may be due to a lack of information or no...
May 1, 2012 at 3:17 pm
I think I'd set max memory to say 4096MB. That would leave about 2GB for the OS.
May 1, 2012 at 2:23 pm
Local System Account does not have access to network resources, iirc.
May 1, 2012 at 2:20 pm
When providing the actual execution, instead of the XML version, save the graphical version as a .sqlplan file and attach that to your post.
May 1, 2012 at 2:14 pm
blandry (5/1/2012)
In your second post you say "Thinking this is what you are trying get so far?" - uh, no... I dont get that many rows as shown in...
May 1, 2012 at 2:12 pm
blandry (5/1/2012)
Lynn Pettis (5/1/2012)
May 1, 2012 at 2:09 pm
And I'm just curious why. Other than curiosity, what is there you are trying to accomplish?
May 1, 2012 at 1:31 pm
If you are that curious, have tried looking in Books Online? It is a very good reference for MS SQL Server.
May 1, 2012 at 1:25 pm
Viewing 15 posts - 12,286 through 12,300 (of 26,486 total)