Viewing 15 posts - 6,901 through 6,915 (of 11,676 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:...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 11, 2012 at 11:44 pm
Change the dimensions to Process Full, that way you'll be sure they have the latest data.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 11, 2012 at 2:17 pm
Viewing 15 posts - 6,901 through 6,915 (of 11,676 total)