Forum Replies Created

Viewing 15 posts - 2,566 through 2,580 (of 19,560 total)

  • RE: Today's Random Word!

    Revenant (7/21/2014)

    SQLRNNR (7/21/2014)

    EL Jerry (7/21/2014)

    Stuart Davies (7/21/2014)

    WOTD wood

    Hard (floor)

    impenetrable

    Adamantium

    fusion

    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

    July 21, 2014 at 9:50 pm

    #1731302

  • RE: Recovery Interval

    Very good question - imho.

    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

    July 21, 2014 at 9:48 pm

    #1731301

  • RE: How to run a SQL job using different account.

    Jeff Moden (7/21/2014)

    Mac1986 (7/21/2014)

    I created a job with a step which has OperatingSystem(CMDEXEC) and run as DOMAIN\MYACCOUNT.

    SQLCMD -q "SQLOPSDB.DBO.sp_now"

    But now the job is not finishing as the above...

    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

    July 21, 2014 at 9:46 pm

    #1731299

  • RE: Generate script to restore log backups

    Jeff Moden (7/21/2014)

    Getting back to the original problem, if you had 2000 log files over the week and did, say, daily DIFs, would you actually delete the log files covered...

    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

    July 21, 2014 at 6:19 pm

    #1731278

  • RE: Users scheduling jobs

    Do the users need to be able to change the schedule of existing jobs or do they need to be able to kick off the job (some people refer to...

    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

    July 21, 2014 at 3:39 pm

    #1731237

  • RE: Generate script to restore log backups

    Jeff Moden (7/21/2014)

    Jack Corbett (7/21/2014)

    SQLRNNR (7/21/2014)

    I am a bit surprised this hasn't been asked yet and it seems REALLY important.

    Why do you have 2000 log backups to restore?

    If...

    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

    July 21, 2014 at 11:36 am

    #1731127

  • RE: CTE with Linked Server: Mulitpart Identifier could not be bound

    Lynn Pettis (7/21/2014)

    Issues.

    Three, and I may be wrong here, but you are going to be pulling the data from all the tables referenced across your network to the server running...

    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

    July 21, 2014 at 11:28 am

    #1731122

  • RE: CTE with Linked Server: Mulitpart Identifier could not be bound

    ChrisM@home (7/21/2014)

    Lynn Pettis (7/21/2014)

    DevNate (7/21/2014)

    Lined server is connected via Symbols.

    So you are saying the Linked Server is hidden by using a synonym? Well, not obvious from what you posted....

    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

    July 21, 2014 at 11:25 am

    #1731121

  • RE: Simple question: How many users are connected to the sql server (instance)?

    smtzac (7/21/2014)

    Thank you Shawn for your reply. I am bit confuse here, when I run your query I get total no. 97 (when i add all) but when I run...

    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

    July 21, 2014 at 11:21 am

    #1731117

  • RE: Generate script to restore log backups

    I am a bit surprised this hasn't been asked yet and it seems REALLY important.

    Why do you have 2000 log backups to restore?

    If you truly have that many log backups...

    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

    July 21, 2014 at 11:04 am

    #1731104

  • RE: Generate script to restore log backups

    Jeff Moden (7/21/2014)

    As a bit of a sidebar, if the MSDB database is still intact, you can use the GUI to do file level restores (it's pretty smart and 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

    July 21, 2014 at 11:00 am

    #1731101

  • RE: SQL Server crashed and the services got stopped

    Is SQL Server the only thing installed on this box?

    Are you using Fulltext search by chance?

    Do you have CLR procs deployed?

    Do you have SSRS or SSIS running on this box?

    Is...

    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

    July 21, 2014 at 10:53 am

    #1731093

  • RE: SQL Server crashed and the services got stopped

    rahulgsingh (7/21/2014)

    Reduce the max server memory of the sql server

    Why?

    They are already only using 50% of the memory allocated to the server. 8Gb available and 4GB set for max...

    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

    July 21, 2014 at 10:48 am

    #1731090

  • RE: Back from Sabbatical

    below86 (7/21/2014)

    Welcome back Steve. Can't wait to hear what you did on your sabbatical. That is a nice perk I wish we all had.:-)

    I agree. Especially if...

    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

    July 21, 2014 at 8:37 am

    #1731039

  • RE: Back from Sabbatical

    Welcome Back

    http://bit.ly/welcombak

    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

    July 21, 2014 at 8:25 am

    #1731030

Viewing 15 posts - 2,566 through 2,580 (of 19,560 total)