Forum Replies Created

Viewing 15 posts - 361 through 375 (of 508 total)

  • RE: Multi-use SQL Server

    If it is such a small amount have you tried direct connections to the database and only logging localy if the connection isn't available? A few thousand transactions shouldn't be...

  • RE: Marthon Assured Availability as SQL Server Host

    I have never heard of marathon endurance server before, I will be more than happy to do some digging and see if anyone has had any problems.

    Cheers,

    Wes

  • RE: Multi-use SQL Server

    What kind of volume are we talking about? I assume you would be using access or MSDE for the desktop yes?

    Wes

  • RE: RAID, Federated Servers and Clustering

    Well, If you talk to compaq they won't support your cluster on anything but a san.

    I would look at a couple of things regarding your setup on a san

    One,...

  • RE: VPN access to a SQL Server 2000 box...

    We were never able to get the EM to connect fully over a SSH connection at my work. I terminal into my main box once the SSH session is connected...

  • RE: Near Realtime Results

    I have seen energy/commodity systems that use a middle tier to keep a much smaller dataset to serve out to help speed things up. The system had a number of...

  • RE: HSM(Hierarchical Storage Management)

    a horazontally partitioned view would do nicely here. I remember HSM now in radioligoy labs used to retrive old xrays and the like.

    Wes

  • RE: HSM(Hierarchical Storage Management)

    Do you need to call a single record inside of twelve years near real time? What are the time constraints. At my last job we kept a SQL server on...

  • RE: HSM(Hierarchical Storage Management)

    Wow, I'm not sure what HSM even does. I may just be slipping a cog can you describe what the product allows you to do?

    Wes

  • RE: AWE memory

    Correct! So, if you ever plan on more than 4 gig in a server you will need to upgrade the OS and SQL 2000 If I am not mistaken. Under...

  • RE: dynamic table dump to file

    lol, Well at least you put me on a diffrent track. I will keep playing with it and see what I can do. Thanks again for your help.

    Wes

  • RE: dynamic table dump to file

    When I print @priorty variable it only has a 0 in it. It doesn't seem to have what should be the output of the select statement. I'll take a look...

  • RE: dynamic table dump to file

    hrum. ok The statement executes but I need to get the results back into variable to later processing. When I run the script it shows the results of the select...

  • RE: dynamic table dump to file

    lol I'm glad you figured it out. I've been busting my head on it for a while. I never even thought about using the built in sp's. Thanks a ton!

    Wes

    ...

  • RE: dynamic table dump to file

    I want to use this type of statement to load up the @hold variable (exec('select top 1 '+@col_list+' from '+@table_name+' order by '+@col_list+' asc'))

    Sorry if I wasn't clear.

    Wes

Viewing 15 posts - 361 through 375 (of 508 total)