Viewing 15 posts - 151 through 165 (of 182 total)
The memusage column is the number of pages in the procedure cache allocated to a process. The page size is 8kb.
memusage * 8 = kb memory allocated for the...
October 14, 2003 at 1:51 pm
When you incrementally update the dimension, it loads new members and updates the name and properties of the existing ones. It doesn't delete any records.
October 8, 2003 at 2:10 pm
Which SP do you have? Try to apply SP3 to AS.
In what format do you have the repository?
October 7, 2003 at 2:04 pm
Try to do separated sums, like this:
WITH
MEMBER [Measures].[Total Date1]
AS 'Sum([date1].[1900].[July], [Measures].[Total Enrolments])', SOLVE_ORDER = 1
MEMBER [Measures].[Total Date2]
AS 'Sum([date2].[2040].[June], [Measures].[Total Enrolments])', SOLVE_ORDER = 1
MEMBER [Measures].[Total Calculated]
AS...
September 19, 2003 at 1:53 pm
I had the same error when I installed just the sp3 for Analysis Services (I have on the same box AS2k and SQL2k). I fixed it installing the sp3 for...
September 18, 2003 at 1:33 pm
Try to update the client with the same OLAP/Pivot Table Service components the server has, i.e. the same service pack that the server has. You can do this by running...
September 16, 2003 at 1:25 pm
To restore just select the first .CAB file, the server continues restoring from each file secuencially.
September 16, 2003 at 1:10 pm
When you archive the database it stores the structure and the data.
If you just backup the files you have to backup the repository too.
September 3, 2003 at 2:14 pm
That may be a security issue, check if you are in the group OLAP Administrators and you have full access to the directory where the repository is (C:\Program Files\Microsoft Analysis...
September 3, 2003 at 2:09 pm
Yes, I did it once.
When you start sql server with minimal it creates the tempdb in the default directory (C:\Program Files\Microsoft SQL Server\MSSQL\Data), then you can connect with query...
August 27, 2003 at 1:45 pm
You can start SQL with minimal configuration (sqlservr -f) and then you can change the location of tempdb file.
August 27, 2003 at 1:35 pm
SQLAudit - http://www.lockwoodtech.com/index_aa.htm
August 14, 2003 at 1:23 pm
Right-click on the TDT, go to properties, options tab, in the field "Insert batch size" enter the number of rows you want.
Keep in mind that if the step fails it...
August 11, 2003 at 1:31 pm
You can use the utility DTSBakcup 2000 (http://www.sqldts.com/default.aspx?t=6&s=105&i=242&p=1&a=0).
Read this article: http://www.sqldts.com/default.aspx?6,105,204,0,0
August 4, 2003 at 1:01 pm
Viewing 15 posts - 151 through 165 (of 182 total)