Forum Replies Created

Viewing 15 posts - 46 through 60 (of 138 total)

  • RE: Linked SQL Tables in Access

    quote:

    What about linked tables and ODBCDirect (don't know if it still exists) or SQL Passthrough Queries?




    Keith Henry


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

    October 29, 2003 at 7:32 am

    #480106

  • RE: Filter for Multi-company Cube

    http://www.microsoft.com/downloads/details.aspx?FamilyId=BEB5D477-2100-4586-A13C-50E56F101720&displaylang=en

    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 29, 2003 at 6:55 am

    #480091

  • RE: To Cluster or not to Cluster

    Clustered indexes change the way all the other indexes on a table work, so this would be a lot dependant on what other indexes are there. It...




    Keith Henry


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

    October 29, 2003 at 3:11 am

    #480044

  • RE: waitresource

    "TAB:" means this is waiting for a table, "29:" refers to Database id 29 in master..sysdatabases.dbid, ":1:" refers to file 1 in sysfiles and ":326542" refers to the...




    Keith Henry


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

    October 29, 2003 at 3:01 am

    #480041

  • RE: Linked SQL Tables in Access

    quote:

    I don't do any Access development, but we do use it (at work, not here) for data management and the linked tables...




    Keith Henry


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

    October 29, 2003 at 1:58 am

    #480023

  • RE: Filter for Multi-company Cube

    What version of OWC can you use? OWC XP can return results from MDX statements but earlier versions can't

    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 29, 2003 at 1:50 am

    #480022

  • RE: QOD 2003-10-23

    http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=17530&FORUM_ID=61&CAT_ID=5&Topic_Title=Question+of+the+day+2+cent&Forum_Title=Anything+that+is+NOT+about+SQL%21

    JordanAC pointed out the same thing. I need to stay up to date more

    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 24, 2003 at 7:34 am

    #479461

  • RE: Linked SQL Tables in Access

    From that description stick with access for the backend. jet to jet is marginly better than jet to sql, but still awful

    Given how amazingly easy...




    Keith Henry


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

    October 24, 2003 at 6:54 am

    #479447

  • RE: Server Farm

    A problem with SQL servers is that they can't share load unless it is done programatically at the application level. I find unioned views across linked servers...




    Keith Henry


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

    October 24, 2003 at 2:19 am

    #479411

  • RE: Question of the day 2 cent

    quote:

    Didn't you make the update to BOL SP3 ???

    Yeah, but I only read...




    Keith Henry


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

    October 23, 2003 at 9:39 am

    #479326

  • RE: Linked SQL Tables in Access

    Don't use linked tables for this, as they are generally even worse than looping through the recordset. In Microsoft Access 2000 and above you can create projects...




    Keith Henry


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

    October 23, 2003 at 9:14 am

    #479320

  • RE: Virtual on Virtual

    You can specify multiple cubes in an MDX statment

    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 23, 2003 at 9:08 am

    #479318

  • RE: QOD 10-21

    quote:

    Sounds like an end user response not a programmer. =)

    In that case it...




    Keith Henry


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

    October 23, 2003 at 8:10 am

    #479301

  • RE: Snitz strange behaviour?

    Sounds like some kind of ASP session timeout

    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 23, 2003 at 3:32 am

    #479240

  • RE: Question of the day 2 cent

    Cool! I love the way MS adds new features with barely any documentation. You should add it as an FAQ

    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 23, 2003 at 3:30 am

    #479239

Viewing 15 posts - 46 through 60 (of 138 total)