Viewing 15 posts - 6,901 through 6,915 (of 11,678 total)
Lynn Pettis (6/12/2012)
OP: I have a problem.
Forum: What?
OP: SQL Server is only using 60 GB of memory and I have max memory set at 100 GB.
Forum:...
June 12, 2012 at 11:41 pm
I usually do all the dimensions in one task and the cube/partitions in another.
It's OK to process dimensions in parallel. If it gives you issues, you can try to group...
June 12, 2012 at 1:19 pm
Lynn Pettis (6/12/2012)
sqlserver8650 (6/12/2012)
Hi ,You can use script componet and write the c# or vb script as per requirements
Why would I use a script component when I can define each...
June 12, 2012 at 1:16 pm
Grant Fritchey (6/12/2012)
Koen Verbeeck (6/12/2012)
Grant Fritchey (6/12/2012)
It's a great and wonderful piece of software, but there's nothing earth-shattering in this release.
Wow wow wow. Hold on!
SSIS has a working undo button...
June 12, 2012 at 6:00 am
Grant Fritchey (6/12/2012)
It's a great and wonderful piece of software, but there's nothing earth-shattering in this release.
Wow wow wow. Hold on!
SSIS has a working undo button and you say this...
June 12, 2012 at 5:52 am
Saga... (6/12/2012)
But SQL 2012 is cloud ready platform... my question is in that context....
because database...
June 12, 2012 at 5:28 am
Normally Process Update shouldn't be hit & miss.
I stumbled across this blog post on MSDN:
Different Kinds of SSAS Processing in simple words…
This particular line is interesting:
ProcessUpdate is inherently slower than...
June 12, 2012 at 5:24 am
That's odd.
When something happens like that, I'd check if everything is configured correctly in SSIS.
June 12, 2012 at 5:01 am
Debbie Edwards (6/12/2012)
The only thing that worries me is the extra time it will take to process everything.
Annoying that Process Updates is so flaky.
Thanks for the...
June 12, 2012 at 2:21 am
aarionsql (6/11/2012)
Is there a way around this in SSIS.
You could code it in .NET. It usually is a bit more flexible and robust than a For Each Loop with...
June 11, 2012 at 11:44 pm
Change the dimensions to Process Full, that way you'll be sure they have the latest data.
June 11, 2012 at 11:23 pm
An "IN" statement like in TSQL can be written by a series of logical ORs.
myColumn IN (1,2,3)
equals to
myColumn == 1 OR myColumn == 2 OR myColumn == 3
June 11, 2012 at 11:21 pm
Craig is right. Either give LANDAUER\sqlservice read/write permission on the AGRESSO_QA database, or execute the jobstep with a proxy.
June 11, 2012 at 11:19 pm
Nice question.
Link to the INTERSECT page:
http://msdn.microsoft.com/en-us/library/ms188055(SQL.105).aspx
June 11, 2012 at 11:15 pm
GilaMonster (6/11/2012)
Koen Verbeeck (6/11/2012)
GilaMonster (6/11/2012)
The way I search for plagiarism/copyright violation is to take a random sentence out of a paragraph and google for that sentence (in quotes)
That wouldn't really...
June 11, 2012 at 2:17 pm
Viewing 15 posts - 6,901 through 6,915 (of 11,678 total)