Forum Replies Created

Viewing 15 posts - 211 through 225 (of 1,179 total)

  • RE: Replication Issues

    What is error no.?

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

  • RE: where can I query the 'Enable Mail Profile' value from the Agent properties

    You can use following:

    EXEC msdb.dbo.sp_set_sqlagent_properties @databasemail_profile=N''

    HTH

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

  • RE: The Results Tab

    Good one, thanks.

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

  • RE: Altering a table is taking lot of time

    Are you doing with GUI or commandline i.e. T-sql?

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

  • RE: How can I check the Long Running Query by using Stats..

    You can find lots on google. Select as per your need.

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

  • RE: Hash Match

    Good One, thanks.

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

  • RE: Remtoe SQL Server backup on local server using SSIS

    pl. provide more details what exactly are you doing? And how you are setting up backup?

    Usually there should not be any issue you can store backup locally as well as...

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

  • RE: The Subtle Push to the Cloud

    This talk is very intersting and many threads are very valid here is my stand:

    In cloud, DBA do not know how their data is taken care? who do have access...

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

  • RE: Backup "fails"

    Yes, message you have posted is clearly mention that backup is successful. Resend the correct message so people can help.

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

  • RE: Am using Windows Server 2008R2,In this C:/ Drive Space getting increase

    Looks like your system is not production. If it's not prod you can change the recover to simple and shrink the logfile. If you would like to keep the full...

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

  • RE: How to fetch count ?

    Replace * with count(*) in your query

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

  • RE: SQL Query

    Refer the execution plan for further understanding.

    However general flow of query is like this...

    Query > Algebrizer > Optimizer > Execution > output

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

  • RE: Latching and Locking...

    Just to head start refer following thread...

    http://www.sqlservercentral.com/Forums/Topic449875-360-1.aspx

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

  • RE: Alter Column

    Good one, thanks.

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

  • RE: multiple inserts multiple connections -blocking

    Evaluate the possibilities of "Snapshot Isolation" in your environment.

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

Viewing 15 posts - 211 through 225 (of 1,179 total)