Forum Replies Created

Viewing 15 posts - 7,831 through 7,845 (of 19,560 total)

  • RE: how to enable Activity Monitor

    Ninja's_RGR'us (11/17/2011)

    If it's still real urgent and you still can't see it you can use this query (it is what activity monitor runs).

    --Borrowed from the activity monitor

    SELECT

    [Session...

    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

    November 17, 2011 at 8:02 am

    #1409225

  • RE: Incorrect syntax near 'GO'

    LOOKUP_BI-756009 (11/17/2011)

    Removed the Go and It worked just fine 🙂

    Thank You Gail & SQLRNNR.

    I am aware as this should not be the right way to get things done, but this...

    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

    November 17, 2011 at 7:49 am

    #1409206

  • RE: Incorrect syntax near 'GO'

    LOOKUP_BI-756009 (11/17/2011)

    SQLRNNR : It works fine if I copy out the results of the execution and execute but if I uncomment 'EXEC sp_executesql @sql' and execute I get the following...

    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

    November 17, 2011 at 7:12 am

    #1409177

  • RE: Where should the DBA position be in the IT structure?

    Ninja's_RGR'us (11/17/2011)

    SQLRNNR (11/17/2011)

    Lowell (11/17/2011)

    SQLRNNR (11/17/2011)

    There is also the 1-man shop type of dba where the DBA /Domain Admin/Janitor pretty much does everything.

    It really depends on the organization as to where...

    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

    November 17, 2011 at 7:04 am

    #1409172

  • RE: Where should the DBA position be in the IT structure?

    Lowell (11/17/2011)

    SQLRNNR (11/17/2011)

    There is also the 1-man shop type of dba where the DBA /Domain Admin/Janitor pretty much does everything.

    It really depends on the organization as to where the DBA...

    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

    November 17, 2011 at 6:03 am

    #1409125

  • RE: Where should the DBA position be in the IT structure?

    There is also the 1-man shop type of dba where the DBA /Domain Admin/Janitor pretty much does everything.

    It really depends on the organization as to where the DBA falls in...

    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

    November 17, 2011 at 5:42 am

    #1409112

  • RE: Performance Monitoring with Dynamic Management Views

    Thanks for the article - good stuff.

    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

    November 17, 2011 at 5:18 am

    #1409098

  • RE: DATETIME Puzzle

    Thanks for the 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

    November 17, 2011 at 5:09 am

    #1409091

  • RE: Table space usage 2

    good question hugo - looks like Steve has fixed it up.

    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

    November 17, 2011 at 5:01 am

    #1409090

  • RE: what causes a database turned into a Recovery State

    The reason is most likely available in your error logs if you are talking about a database suddenly showing up in the "recovering" state.

    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

    November 16, 2011 at 5:16 pm

    #1408933

  • RE: Incorrect syntax near 'GO'

    Try not executing the sql and ensure the tsql prints correctly. If it does then copy that into a new query window (the message results from the print) and...

    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

    November 16, 2011 at 4:42 pm

    #1408929

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (11/16/2011)

    Why, what would you guys do in his shoes?

    Dev (11/16/2011)

    I had one of those. I sat down with the architect and explained to him what NoLock actually...

    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

    November 16, 2011 at 11:02 am

    #1408764

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (11/16/2011)

    L' Eomot Inversé (11/16/2011)

    Ninja's_RGR'us (11/16/2011)

    I got to remember that one!

    http://www.sqlservercentral.com/Forums/Topic1206736-391-1.aspx

    GilaMonster (11/16/2011)

    ashuthinks (11/16/2011)

    i.m just using this stored procedure for reporting purpose..

    please let me know my usage is at right...

    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

    November 16, 2011 at 9:29 am

    #1408679

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (11/16/2011)

    I got to remember that one!

    http://www.sqlservercentral.com/Forums/Topic1206736-391-1.aspx

    GilaMonster (11/16/2011)

    ashuthinks (11/16/2011)

    i.m just using this stored procedure for reporting purpose..

    please let me know my usage is at right or not?

    Since when does reporting...

    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

    November 16, 2011 at 8:35 am

    #1408613

  • RE: Today's Random Word!

    Ninja's_RGR'us (11/16/2011)

    SQLRNNR (11/16/2011)

    Ninja's_RGR'us (11/16/2011)

    crookj (11/16/2011)

    SQLRNNR (11/16/2011)

    slip

    slip sliding away...

    snow... as in first snow of the year tomorrow.

    Don't hold your breath

    Dude, I live way up there in the north 😀

    And I have...

    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

    November 16, 2011 at 8:01 am

    #1408561

Viewing 15 posts - 7,831 through 7,845 (of 19,560 total)