Forum Replies Created

Viewing 15 posts - 121 through 135 (of 138 total)

  • RE: Cube size Vs Storage Space size

    In your MSOLAP dir:

    • FoodMart 2000\Sales\Sales.fact.data is the cube
    • FoodMart 2000\Sales\Sales.agg.rigid.data is your aggregations

    These files will be different in cubes with changeing dimensions...




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 17, 2003 at 2:32 am

    #474576

  • RE: OLAP and MS SQL on the same machine...

    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...




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 17, 2003 at 2:17 am

    #474573

  • RE: Drill Thru using Excel XP againt Analysis Services

    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,...




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 16, 2003 at 8:07 am

    #474425

  • RE: big bonus for answering on-the-day

    quote:

    Would be harsh and would unfairly punish those that cannot answer on the same day because they're away on business.




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 16, 2003 at 7:59 am

    #474422

  • RE: QOD 12 Sept 03

    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...




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 16, 2003 at 3:35 am

    #474346

  • RE: QOD 11 Sep 2003

    quote:

    What I am saying is that in all the documentation I have found indid >= 2 is a non-clustered index not a...




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 11, 2003 at 9:12 am

    #473744

  • RE: QOD 11 Sep 2003

    quote:

    DBA relevant maybe, but not developer relevant. Especially on a table only containing 24 rows.




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 11, 2003 at 4:48 am

    #473664

  • RE: QOD 11 Sep 2003

    quote:

    4) The data has a non-clustered index called _WA_Sys_lastname_5031C87B

    This can't be right...




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 11, 2003 at 4:33 am

    #473660

  • RE: QOD 11 Sep 2003

    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. ...




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 11, 2003 at 2:06 am

    #473630

  • RE: Create RSS file

    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...




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 10, 2003 at 3:37 am

    #473373

  • RE: QOD 10/10/2003

    Thanks.

    Keith Henry




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 10, 2003 at 3:21 am

    #473369

  • RE: QOD 9/5/2003

    quote:

    Although the OS is clustered a single instance is running as a secondary instance on one node. I do believe, unless someone...




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 8, 2003 at 6:21 am

    #473006

  • RE: QOD 9/5/2003

    Two servers Active/Active

    Node 1 A : cls01\inst1 (4 processor lic)

    Node 2 A : cls02\inst2 (4 processor lic)

    cls02\inst3 (no extra...




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 5, 2003 at 2:28 am

    #472754

  • RE: QOD 4th Sept 2003

    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,...




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 4, 2003 at 4:56 am

    #472511

  • RE: QOD 4th Sept 2003

    Useful script:

     /*
    Following on from todays QOD (on xp_cmdshell permissions) I thought this might be useful.
    Takes a directory...




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 4, 2003 at 4:45 am

    #472506

    • Viewing 15 posts - 121 through 135 (of 138 total)