Viewing 15 posts - 1 through 15 (of 40 total)
Thanks for the Response. I have read Joe's article, but he does not go into details of setting up the Cache - to quote "I am not going to explain...
May 23, 2016 at 8:48 am
Thanks for the quick response Steve.
Yes, I should have added that local disk could be an option. As the company is more geared towards the use of SANs and...
October 14, 2007 at 11:31 am
What Recovery model are you using on the Database? If you are using the "Full" recovery model then you have a few options using the Transaction Log.
January 3, 2007 at 8:25 am
Thanks for your comments.
Yes, we are dropping and re-loading data each day, as the system that we are loading from does not have any way of identifying new or changed...
January 3, 2007 at 6:29 am
Many thanks for the response.
We are using SQL Server Enterprise. We do not currently know if we can add physical memory (it is an old box, and will be...
January 2, 2007 at 11:08 am
Hi Clay G,
Thanks for your response. I deliberately renamed all of the object names for anonymity, but this seems to have caused more confusion than it was worth.
We have now...
July 26, 2004 at 1:29 am
Just to complete the post with info for others facing the same issue, we resolved the problem by re-applying the filter to the data returned by the Drillthrough prior...
July 23, 2004 at 4:16 am
Many thanks for your response. In my example, "World" does not correspond to the All Level, so hiding the All level would not help. Profiler is great for monitoring...
July 6, 2004 at 10:21 am
Back in the days of SQL 7, we migrated it into a separate database and called it OLAP_Rep.
When the name change came with SQL 2000, some bright spark decided...
June 9, 2003 at 10:19 am
Many thanks, Andy, for putting me out of my misery.
I had tried various searches on gibtab and gibcol together - gibberish seems entirely appropriate here.
wibble, wibble, wibble (with apologies to...
April 14, 2003 at 9:42 am
Hi there, no response as yet!
Please could someone try the following:
Set up a trace on a SQL Server running Analysis Services 2000, under Events select 'Errors and Warnings' in addition...
April 14, 2003 at 7:25 am
You're a bit off-topic with this question in this forum, but try the following url on this same site - the question has been answered before in the 'Administration'...
March 6, 2003 at 9:54 am
Thanks for your responses, Phil and Anzio - very clear.
Unfortunately, I was hoping to find a solution without changing the Precedence of following tasks - I knew about this being...
February 5, 2003 at 8:22 am
As I see it, you can only successfully use DTSExecStat_Success at the end of an ActiveX Script step. I need to set other types of steps off also...
February 4, 2003 at 7:43 am
Thanks for your suggestions.
AnzioBake - Sorry, but I don't really understand your suggestion - could you flesh it out with a bit more detail for the example?
Andrew, the use of...
February 3, 2003 at 6:37 am