Forum Replies Created

Viewing 15 posts - 15,916 through 15,930 (of 19,560 total)

  • RE: Setting up security to a view

    You're welcome.

    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

    March 25, 2010 at 4:23 pm

    #1140055

  • RE: Burnout

    Nice read. Burnout is a serious issue and needs to be handled properly.

    Thanks for outlining the symptoms and a good solution. If management is apathetic towards the employee,...

    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

    March 25, 2010 at 1:33 pm

    #1139982

  • RE: Are the posted questions getting worse?

    Yup - time to unsubscribe.

    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

    March 25, 2010 at 1:10 pm

    #1139956

  • RE: T-SQL: Why “It Depends”

    BlackHawk-17 (3/25/2010)

    Based on this article from the CSS SQL Server Engineers team I think you are on the wrong path.

    Compact is not defragment. It goes back to the Paul Randall...

    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

    March 25, 2010 at 1:09 pm

    #1139954

  • RE: T-SQL: Why “It Depends”

    For giggles, I just checked sp_who2 which also shows the DBCCFilesCompact.

    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

    March 25, 2010 at 1:01 pm

    #1139949

  • RE: Are the posted questions getting worse?

    Paul White NZ (3/25/2010)

    Trey Staker (3/25/2010)

    I'm not huge on tittles so I've never bothered to have it changed.

    It's not the title so much - I don't recall ever having 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

    March 25, 2010 at 12:38 pm

    #1139938

  • RE: Run an SSIS Package Under a Different Account

    Grey Cat (3/25/2010)

    Thanks for all the comments. It's encouraging.:-)

    You're welcome.

    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

    March 25, 2010 at 12:35 pm

    #1139936

  • RE: T-SQL: Why “It Depends”

    The script where I was first able to trap this info was designed for SQL 2000, thus needs some updating. I have seen it capture this the FilesCompact 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

    March 25, 2010 at 12:33 pm

    #1139935

  • RE: Are the posted questions getting worse?

    Paul White NZ (3/25/2010)

    CirquedeSQLeil (3/25/2010)

    Paul White NZ (3/25/2010)

    Anyone else dislike the term 'DBA'?

    In which sense?

    Database Administrator

    The term is fine with me. Why do you dislike 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

    March 25, 2010 at 12:03 pm

    #1139907

  • RE: T-SQL: Why “It Depends”

    Paul White NZ (3/25/2010)

    I am still trying to catch the DBCC commands in a trace - I get the shrink events and a blank DBCC event, but not the thing...

    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

    March 25, 2010 at 12:02 pm

    #1139906

  • RE: Are the posted questions getting worse?

    Paul White NZ (3/25/2010)

    Anyone else dislike the term 'DBA'?

    Database Associate

    Database Admin

    Database Architect

    Database Aura

    Database Alumni

    In which sense?

    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

    March 25, 2010 at 12:00 pm

    #1139901

  • RE: Are the posted questions getting worse?

    Grant Fritchey (3/25/2010)

    The Dixie Flatline (3/25/2010)

    ARID = Alternate Reality ID.

    I believe it's parameter 117, but I'd have to confirm that with Gail.

    And that's a GUID right?

    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

    March 25, 2010 at 11:59 am

    #1139900

  • RE: Are the posted questions getting worse?

    Alvin Ramard (3/25/2010)

    Trey Staker (3/25/2010)

    Anyone have anything light or funny to move this thread back into the right direction?:-D

    Trey, can you add 2 dashes in front of the command? ...

    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

    March 25, 2010 at 11:58 am

    #1139896

  • RE: Bad Practice

    Lynn Pettis (3/25/2010)

    Also, iirc, the TRUNCATE_ONLY option on BACKUP LOG has also been depreciated as well.

    Yes it 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

    March 25, 2010 at 11:46 am

    #1139881

  • RE: Run an SSIS Package Under a Different Account

    Useful article on the use of Proxy accounts.

    Thanks for the article.

    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

    March 25, 2010 at 11:39 am

    #1139872

Viewing 15 posts - 15,916 through 15,930 (of 19,560 total)