Forum Replies Created

Viewing 15 posts - 7,066 through 7,080 (of 19,560 total)

  • RE: Seems master db got corrupt.Please help.

    Try connecting with DAC

    http://msdn.microsoft.com/en-us/library/ms189595.aspx

    See if you can gain access that way.

    In the meantime, do you have backups of your master database?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 19, 2012 at 12:24 am

    #1435670

  • RE: Raw Materials - Surface Area

    Trey Staker (7/22/2010)

    I used to work with a DBA who was a pretty good lock pick. We had a server down on a saturday and neither of us had...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 19, 2012 at 12:21 am

    #1435668

  • RE: String or binary data would be truncated -- Mysterious

    That would be the cause. I would find out which one is the correct size and make all of them the same size.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 19, 2012 at 12:17 am

    #1435664

  • RE: Better Than Batman

    Thanks for introducing me to Breadpig - that is a new one for me.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 19, 2012 at 12:16 am

    #1435663

  • RE: String or binary data would be truncated -- Mysterious

    Have you tried commenting out that column and rerunning the Insert? What are the column definitions for the remaining columns?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 19, 2012 at 12:11 am

    #1435661

  • RE: Seems master db got corrupt.Please help.

    Have you run DBCC Checkdb as the error suggests?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 19, 2012 at 12:07 am

    #1435660

  • RE: SSIS OLEDB Destination Options

    I learned something new today - again.

    Yay.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 19, 2012 at 12:04 am

    #1435659

  • RE: Hi....

    Are you logging in with an account that has security admin or sysadmin permissions?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 18, 2012 at 8:12 pm

    #1435636

  • RE: Fastest Method for Moving Large Database Backups to New Location

    Something we have done is to backup the files to a USB drive and then courier the USB drive to the remote location.

    For the differences between the two locations, do...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 18, 2012 at 6:06 pm

    #1435618

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (1/18/2012)

    SQLRNNR (1/18/2012)

    anybody know a good resource for exporting into sqlplan format the xml from sys.dm_exec_query_plan(qs.plan_handle) for a smallish subset of ~100 plans?

    I have been able to copy...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 18, 2012 at 5:37 pm

    #1435612

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (1/18/2012)

    SQLRNNR (1/18/2012)

    Gianluca Sartori (1/18/2012)

    SQLRNNR (1/18/2012)

    anybody know a good resource for exporting into sqlplan format the xml from sys.dm_exec_query_plan(qs.plan_handle) for a smallish subset of ~100 plans?

    I have been able...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 18, 2012 at 2:28 pm

    #1435525

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (1/18/2012)

    SQLRNNR (1/18/2012)

    anybody know a good resource for exporting into sqlplan format the xml from sys.dm_exec_query_plan(qs.plan_handle) for a smallish subset of ~100 plans?

    I have been able to copy the...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 18, 2012 at 2:23 pm

    #1435520

  • RE: Are the posted questions getting worse?

    anybody know a good resource for exporting into sqlplan format the xml from sys.dm_exec_query_plan(qs.plan_handle) for a smallish subset of ~100 plans?

    I have been able to copy the xml and get...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 18, 2012 at 1:33 pm

    #1435481

  • RE: Today's Random Word!

    crookj (1/18/2012)

    WOTD - misnomer

    miss gomer

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 18, 2012 at 10:44 am

    #1435401

  • RE: Model DB

    SqlMel (1/18/2012)

    This was an excellent question. Very odd behavior when using the wizard. These things are always good to know.

    Glad you liked it.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 18, 2012 at 10:21 am

    #1435391

Viewing 15 posts - 7,066 through 7,080 (of 19,560 total)