Forum Replies Created

Viewing 15 posts - 7,696 through 7,710 (of 19,560 total)

  • RE: Multi Line output column

    Can you provide an example of what the output should look like?

    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

    December 1, 2011 at 9:37 pm

    #1415680

  • RE: t sql funny

    hmmm, it might look a bit like a pile on - can we revert back to the topic? 😉

    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

    December 1, 2011 at 7:17 pm

    #1415670

  • RE: shrink taking long - suggestions

    Evil Kraig F (12/1/2011)

    fave_dba (12/1/2011)

    We have a request from application team to refresh database for testing. This will be here for a short period and the drive space is low....

    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

    December 1, 2011 at 4:49 pm

    #1415651

  • RE: Today's Random Word!

    froyo

    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

    December 1, 2011 at 2:27 pm

    #1415600

  • RE: Log Shipping + Transaction Log Backups to save space

    nathanr 81822 (12/1/2011)

    I can shrink it in the mean time and get the space issues sorted out later. (i.e. buy a new hard disk and rebuild the server etc)

    What will...

    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

    December 1, 2011 at 10:32 am

    #1415431

  • RE: Quorum Disk on SQL Cluster, on passive node issue

    For the brief moment while transitioning the cluster will not see it (milliseconds maybe). And in case it doesn't move successfully then it could be longer. I would...

    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

    December 1, 2011 at 10:29 am

    #1415421

  • RE: Log Shipping + Transaction Log Backups to save space

    If you are running out of disk space, I would recommend adding more space first.

    If not possible, you can look at shrinking it. Problem with that is the log...

    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

    December 1, 2011 at 10:24 am

    #1415416

  • RE: Are the posted questions getting worse?

    Slick - definitely moving up higher on the list of software to use.

    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

    December 1, 2011 at 10:08 am

    #1415400

  • RE: Orphaned users with \ in username

    try using [] around the login in question.

    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

    December 1, 2011 at 10:06 am

    #1415398

  • RE: Log Shipping + Transaction Log Backups to save space

    If you perform a log backup outside of the logshipping, it will break the log chain. Then your logshipping t-log backups will not be able to restore to 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

    December 1, 2011 at 10:04 am

    #1415396

  • RE: Are the posted questions getting worse?

    GSquared (12/1/2011)

    GilaMonster (12/1/2011)

    Today's nugget of wisdom - when computer is giving all sorts of drive-related errors, first check that the sata cables are properly seated, especially if the computer has...

    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

    December 1, 2011 at 10:02 am

    #1415395

  • RE: Are the posted questions getting worse?

    GilaMonster (12/1/2011)

    SQLRNNR (12/1/2011)

    Wouldn't that just suck. You don't still have the drive by chance?

    I do still have it. Once I get the server installed I'll stick it in there...

    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

    December 1, 2011 at 9:52 am

    #1415381

  • RE: Incorrect syntax near 'left'

    slizam (11/30/2011)

    thanks for reply my topic Lynn Pettis...

    the problem is, it sometimes get error when i use keyword 'LEFT' in SQL server 2000. can i know the related topic here?

    You...

    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

    December 1, 2011 at 9:48 am

    #1415378

  • RE: Are the posted questions getting worse?

    GilaMonster (12/1/2011)

    Today's nugget of wisdom - when computer is giving all sorts of drive-related errors, first check that the sata cables are properly seated, especially if the computer has been...

    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

    December 1, 2011 at 9:42 am

    #1415370

  • RE: Are the posted questions getting worse?

    GSquared (12/1/2011)

    My wife and I are celebrating our 21st anniversary today. As part of that, I'm taking next week off of work (my third vacation since 1988), and probably...

    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

    December 1, 2011 at 9:28 am

    #1415357

Viewing 15 posts - 7,696 through 7,710 (of 19,560 total)