Forum Replies Created

Viewing 15 posts - 781 through 795 (of 3,061 total)

  • RE: sp_cursoropen very slow on 1 table on 1 server but other tables/servers are ok

    sotn (11/6/2011)


    This is a very wierd, major performance issue so any help/pointers, grately appreciated.

    We migrating from SQL 2005 to SQL 2008R2 SP1 64-bit, and use Navision, so we don't have...

  • RE: CLRs and minimum permission set

    happiestgirl (11/1/2011)


    I've been looking for some down to earth explanation of TRUSTWORTHY permissions concerning CLR assemblies. When should it be ON and when OFF when deploying one?

    I looked in...

  • RE: production web application performance degradation due to database issues

    Do you have a DBA on the organization?

    - In the affirmative case, what she/he say about it?

    - In the negative case, who designed the database?

    Identify the three queries...

  • RE: Big Data, Many Challenges

    In my view there are two very different things going on, on one side "Business Support" systems like ledger, billing, financials, etc. which should stay as they are and, "Decision...

  • RE: Something you could never do in sql server

    GSquared (11/4/2011)


    ... I had a rollback command once that took over a week to finish. On a command that had been running for about 30 seconds.

    Most probably something blocked...

  • RE: Something you could never do in sql server

    foxjazzG (11/3/2011)


    that can be done in Oracle.

    run a relatively simple query that takes 16 + hours.

    I've seen that before - we call it extremelly poorly written code running in extremelly...

  • RE: One database, copied to two identical servers. Performance bad on second server. Why?

    Paul Koanui (11/1/2011)


    I'm not a DBA and I'm confused at the cause of the behavior I'm seeing. I have two identical servers (cloud servers setup from the same image)...

  • RE: Knowledge capicity of a DBA

    Welcome to the wonderful world of database administration.

    If you are asking yourself that kind of question you are in the right path - congrats!

  • RE: Help with Linked Query Setup for Oracle

    coder_t2 (10/31/2011)


    Hey guys, I am trying to setup a linked query to an oracle server on my machine. I am using Sql Server 2008 and a 64-bit OS. I have...

  • RE: Poll - "SQL Server Administrator"

    Warren Peace (10/27/2011)


    PaulB-TheOneAndOnly (10/27/2011)


    Well... in a fifty serves environment is reasonable to have a well established division of responsibilities.

    Weekend pages are part of our job or as one of my...

  • RE: Best Practice - What makes the most sense?

    david.ostrander (9/14/2011)


    No real-time access to the production data is not a requirement. That is the good news out of all this. 🙂

    The easiest way - which wouldn't even requiere to...

  • RE: Poll - "SQL Server Administrator"

    Well... in a fifty serves environment is reasonable to have a well established division of responsibilities.

    Weekend pages are part of our job or as one of my bosses used to...

  • RE: Newbie DBS needs SQL index rebuild help!

    I'm in agreement with Calvo.

    Furthermore, I would suggest to implement a weekly or monthly Maintenance Window during which you would have total control of the database and perform any maintenance...

  • RE: Replication or something else?

    jared-709193 (10/27/2011)


    PaulB-TheOneAndOnly (10/27/2011)


    jared-709193 (10/27/2011)


    Scenario:

    Application may be routed to 1 of 4 servers depending on load and location: Colorado, Michigan, 2 Illinois. Data from each server needs to be replicated to...

  • RE: optiontips.in

    optiontips.in (10/23/2011)


    My requirement is, based on the input selection from the frontend we have to query the database and then display the records based on the input. Sometimes we may...

Viewing 15 posts - 781 through 795 (of 3,061 total)