Forum Replies Created

Viewing 15 posts - 31 through 45 (of 138 total)

  • RE: Other types of database

    Thanks for the response

    quote:

    It is recommended that bitmaps are best suited when the cardinality of the column is low.

    For...




    Keith Henry


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

    November 27, 2003 at 2:54 am

    #483877

  • RE: Other types of database

    Turns out that bitmap indexes are quite a standard form of index.

    They are used for highly non-specfic but non-unique data in large datasets (eg...




    Keith Henry


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

    November 26, 2003 at 8:01 am

    #483748

  • RE: Other types of database

    Thanks for the response...

    quote:

    Hope this info helps (you stay with MSSQL [:-)]).




    Keith Henry


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

    November 26, 2003 at 2:33 am

    #483673

  • RE: Query error

    I've seen this before, but when trying to execute for xml statements in QA with show plan on.

    When you say "directly on the server" what do...




    Keith Henry


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

    November 18, 2003 at 4:10 am

    #482392

  • RE: Organizational Hierarchy

    Depends on how your data is structured

    If you have a parent id against each company centre that links it to another then you have a parent-child...




    Keith Henry


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

    November 18, 2003 at 3:42 am

    #482391

  • RE: QOD 17th Nov

    quote:

    Certainly beats the hell out of some of Keith's questions, which I'd love to refute if I could understand them.




    Keith Henry


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

    November 18, 2003 at 3:31 am

    #482386

  • RE: QOD 17th Nov

    quote:

    OK, well, thanks for the skewer. I'll think twice about posting a question from now on. ;-/




    Keith Henry


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

    November 18, 2003 at 1:45 am

    #482369

  • RE: QOD 17th Nov

    I got it wrong too, in full knowleged of ordinal numbers SPs and the version behaviour of DTS I picked DTS.

    Never a fan of complaining becaue...




    Keith Henry


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

    November 17, 2003 at 2:23 am

    #482170

  • RE: Does Access effect SQL Server Perfomance

    Using Access Projects (where Jet is dumped and the access file conatins forms and reports but no data) that will work fine.

    Using Access Linked tables then...




    Keith Henry


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

    November 3, 2003 at 3:31 am

    #480604

  • RE: To Cluster or not to Cluster

    quote:

    Each table should have a clustered index.

    Definately not!




    Keith Henry


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

    November 3, 2003 at 2:20 am

    #480601

  • RE: Cube Editor Error

    Right click the database connection and its the last tab along the top. What you can put in there involves trawling through the OLEDB for SQL server...




    Keith Henry


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

    October 31, 2003 at 1:44 am

    #480409

  • RE: Cube Editor Error

    Probably some way to force it in the extended properties of the connection string...

    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 30, 2003 at 2:37 am

    #480255

  • RE: Book on OLAP?

    I have an FAQ "pending approval" on this one:

    Beginners should look at

    "Fast Track to MDX" ISBN: 1-852-33681-1

    Good beginners stuff but lacking...




    Keith Henry


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

    October 30, 2003 at 2:22 am

    #480253

  • RE: error connecting to sql server

    Not really Access but: Does your server have an instance name? e.g. server\inst1 If so you will need MDAC 2.6 or better on all clients...




    Keith Henry


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

    October 30, 2003 at 2:19 am

    #480252

  • RE: QOD 10-30

    Thanks for the help!

    I picked the only one it couldn't do and got it right, just goes to show that it's worth...




    Keith Henry


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

    October 30, 2003 at 1:56 am

    #480248

    • Viewing 15 posts - 31 through 45 (of 138 total)