Forum Replies Created

Viewing 15 posts - 31 through 45 (of 137 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...

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

    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 [:-)]).

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

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

    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.

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

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

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

    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!

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

    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

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

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

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

    October 30, 2003 at 1:56 am

    #480248

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