Viewing 15 posts - 1,591 through 1,605 (of 11,676 total)
Ed Wagner (10/21/2014)
Sean Lange (10/21/2014)
rodjkidd (10/21/2014)
spaghettidba (10/21/2014)
rodjkidd (10/21/2014)
spaghettidba (10/21/2014)
Ed Wagner (10/21/2014)
Gianluca, where are you located in Italy?I'm in Conegliano, home of the Prosecco sparkling wine.
It's 50 km from Venice.
Welcome back...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 21, 2014 at 12:18 pm
spaghettidba (10/21/2014)
It's been a very long time since I last posted on THE thread...
Actually it's been a very long time since I posted regularly on the forums, but now I...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 21, 2014 at 7:01 am
Depending on the kind of error, the entire flat file might be regarded as erroneous.
For example, if a delimiter is missing, it might mess up all the rows that come...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 21, 2014 at 4:07 am
Take a look at this excellent splitter function by Jeff Moden[/url].
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 21, 2014 at 4:02 am
You only want data from one patient?
Is patientID the same across all dimensions?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 21, 2014 at 2:12 am
Instead of doing this probably quite costly migration, why don't you create a simple ODS or data warehouse?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 21, 2014 at 12:42 am
Something like this?
DECLARE @CurrentTerm VARCHAR(10) = 'Term5';
SELECT studentID, PrevFailTerm = MAX(Term), CurrentTerm = @CurrentTerm
FROM myTable
WHERE Term < @CurrentTerm AND Result = 'Fail'
GROUP BY studentID;
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 21, 2014 at 12:41 am
Very excellent question.
Thanks Sean.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 21, 2014 at 12:36 am
With SSIS package logging you mean the logging you define yourself in the package?
Personally I would store these in a seperate database, not in the SSRS database or the SSIS...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 20, 2014 at 12:42 pm
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 20, 2014 at 12:42 am
chalam87 (10/17/2014)
will it update view when ever underlying tables insert,update and delete records will have any performance issue.
Is it an indexed view?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 17, 2014 at 7:45 am
dapoole (10/17/2014)
Finally some helpful ideas.
If you find that any advice given to you was below your standards of quality, the people that gave you the advice will gladly refund the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 17, 2014 at 7:00 am
What is the error?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 17, 2014 at 6:40 am
It seems someone's account has expired. Contact the administrator in charge of Active Directory.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 17, 2014 at 5:51 am
A clustered index doesn't need to be of data type int. Typically you would create your clustered index key as small as possible though.
I would just ignore the advisor (as...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 17, 2014 at 5:49 am
Viewing 15 posts - 1,591 through 1,605 (of 11,676 total)