Forum Replies Created

Viewing 15 posts - 541 through 555 (of 1,179 total)

  • RE: Temporary table in a batch

    Good One.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: Analysis Services Tabular

    Good to see recent questions on BI/DW.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: Moving Standby/Readonly DB to New server

    Detach / Attach will not work on Stand by / Read only database.

    What you are trying to achieve?

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: Analysis Services Multidimensional

    Not an easy one. But good QotD.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: Best all-round monitoring tool for

    I have used ignite and good for performance perspective i.e. long running queries.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: Tracing user actions

    In addition resource of the server too may be affected i.e. CPU, MEMORY, I/O etc.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: Execution Plans

    Nice question, Steve.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: What's the fatest way to restore? SSIS

    What do you mean by takes forever? I guess very very slow?

    howmuch is the size of the database? Try restore using creating job and check? What are the other...

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: Can't connect to stand alone Server not in a Domain

    Yes, Firewall is culprit most of the time. 🙂

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: Database 'BizTalkEDIDb' is not valid to be included in the maintenance plan.

    Check this out

    http://connect.microsoft.com/SQLServer/feedback/details/320955/backup-maintenance-plan-involving-snapshot-database

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: Compression

    Good one.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: Deadlock graph information with xml format.

    There are multiple ways...

    1. If possible change the execution timings if there are more than one jobs or proc executed at same time. Or

    2. If possible use nolock option...

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: CPU USAGE IS 100%

    Find out which process is taking more CPU utilization. Memory looks ok.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: SQL Server Health and History Tool

    Nice question. +1

    Though searching for check box instead of radio button.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: Replication

    Good one! help to sharpen Replication skill... recalling old memories 🙂

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

Viewing 15 posts - 541 through 555 (of 1,179 total)