Forum Replies Created

Viewing 15 posts - 76 through 90 (of 138 total)

  • RE: Locking, blocking, killing!

    quote:

    Somebody has advised to store the text fields in separate tables which will be linked to the original table with the GUID...




    Keith Henry


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

    October 2, 2003 at 8:57 am

    #476793

  • RE: Duplicate Indexes

    This is bad in almost every case, however there is one situation where there might be a good reason. Are they both in the same direction?

    Keith Henry

    DBA/Developer/BI...




    Keith Henry


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

    October 2, 2003 at 8:47 am

    #476788

  • RE: Selecting XML out

    Doh! yes.

    Stags sent me an email and I helped him out directly in the end

    Keith Henry

    DBA/Developer/BI Manager




    Keith Henry


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

    October 2, 2003 at 8:33 am

    #476784

  • RE: Unable to Browse Data in a cube

    Welcome to the !Joy! of debugging MSOLAP. It's handled errors are about as helpful as a sackful of pissed monkeys.

    Is this the only cube with...




    Keith Henry


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

    October 2, 2003 at 8:21 am

    #476777

  • RE: QOD 01/10/2003

    quote:

    In normal practise this is considered as datetime.

    What normal practise?

    Keith Henry

    DBA/Developer/BI Manager




    Keith Henry


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

    October 2, 2003 at 8:10 am

    #476771

  • RE: QOD 01/10/2003

    quote:

    What is it with you English speaking persons that you seem to have a problem understanding your own language?




    Keith Henry


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

    October 2, 2003 at 8:08 am

    #476767

  • RE: IAM Page Out of Range

    What indexes are on this table and does it have any text/ntext/image fields?

    Keith Henry

    DBA/Developer/BI Manager




    Keith Henry


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

    October 2, 2003 at 1:57 am

    #476693

  • RE: QOD 01/10/2003

    It wasn't that confusing. It was still obvious what the answer was. The QOD tends not to be "English Logic Tricks" but SQL tests. Maybe...




    Keith Henry


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

    October 1, 2003 at 10:05 am

    #476582

  • RE: Selecting XML out

    select 1 as tag, null as parent,

    'whatever' as [FREEFORMENDORSEMENT-EW502!1!attrib],

    null as [HEADING!2!!element],

    null as [DESCRIPTION!3!line],

    null as [DESCRIPTION!3!!element]

    union all

    To be honest this is the sort of situation where direct SQL may be better. OLAP is very very good for mining style reports; How many dodads...




    Keith Henry


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

    September 30, 2003 at 3:34 am

    #476327

  • RE: greater than > and less than < in MDX

    quote:

    thanks steve,

    i can't seem to work out how to use that in a calculated member.




    Keith Henry


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

    September 30, 2003 at 1:57 am

    #476307

  • RE: MS Access versus SQL Server

    MSDE (the FREE version of SQL) beats Access in every possible way. Therefore cost is no reason to pick Jet.

    The Jet engine does, will and...




    Keith Henry


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

    September 30, 2003 at 1:51 am

    #476306

  • RE: Access Query Deadlocks SQL Process

    quote:

    Ok, sorry, I had assumed you were using an access project to run the queries(stored procs) on the server. It looks like...




    Keith Henry


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

    September 30, 2003 at 1:43 am

    #476304

  • RE: how to retrieve from database crash

    In access?

    Keith Henry

    DBA/Developer/BI Manager




    Keith Henry


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

    September 30, 2003 at 1:35 am

    #476302

  • RE: greater than > and less than < in MDX

    That'll be the aggregations on the cube, you need to add them to start and end dates, also you don't need the dates to go off as far...




    Keith Henry


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

    September 28, 2003 at 12:12 am

    #476100

    • Viewing 15 posts - 76 through 90 (of 138 total)