Viewing 15 posts - 121 through 135 (of 137 total)
In your MSOLAP dir:
These files will be different in cubes with changeing dimensions...
September 17, 2003 at 2:32 am
You could do this and there can be good reasons for, but you would have to carefully plan your resources
MOLAP Cubes don't take up much space...
September 17, 2003 at 2:17 am
OWC XP is pretty damn good for a free add on to office, but it only has a very minimal set of what a proper BI client tool can do,...
September 16, 2003 at 8:07 am
quote:
Would be harsh and would unfairly punish those that cannot answer on the same day because they're away on business.
September 16, 2003 at 7:59 am
I checked on the day and most people had it wrong. Today most have it right.
I tried to recruite someone who knew MDX recently and...
September 16, 2003 at 3:35 am
quote:
What I am saying is that in all the documentation I have found indid >= 2 is a non-clustered index not a...
September 11, 2003 at 9:12 am
quote:
DBA relevant maybe, but not developer relevant. Especially on a table only containing 24 rows.
September 11, 2003 at 4:48 am
quote:
4) The data has a non-clustered index called _WA_Sys_lastname_5031C87B
This can't be right...
September 11, 2003 at 4:33 am
As a general rule any good SQL developer or DBA needs to know their way around the sysindexes table and exactly how sql stores and accesses indexes. ...
September 11, 2003 at 2:06 am
Set up SQLXML pointing at your news database set up to accept templates only
Write a template file using for xml to produce your xml rowset. This tempate...
September 10, 2003 at 3:37 am
quote:
Although the OS is clustered a single instance is running as a secondary instance on one node. I do believe, unless someone...
September 8, 2003 at 6:21 am
Two servers Active/Active
Node 1 A : cls01\inst1 (4 processor lic)
Node 2 A : cls02\inst2 (4 processor lic)
cls02\inst3 (no extra...
September 5, 2003 at 2:28 am
quote:
I can't agree with the given answer. I ran the query without having permission to xp_cmdshell and got the error stated. However,...
September 4, 2003 at 4:56 am
Useful script:
/*
Following on from todays QOD (on xp_cmdshell permissions) I thought this might be useful.
Takes a directory...
September 4, 2003 at 4:45 am
Viewing 15 posts - 121 through 135 (of 137 total)