Forum Replies Created

Viewing 15 posts - 1,486 through 1,500 (of 19,560 total)

  • RE: SSMS with RUNAS – trapping failed network logon

    I like the option presented by MM.

    Just throwing out another option. At a previous employer, we used a posh script to authenticate and launch ssms. If the creds were...

    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 27, 2015 at 8:41 am

    #1786918

  • RE: Today's Random Word!

    retriever

    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 27, 2015 at 7:37 am

    #1786877

  • RE: Are the posted questions getting worse?

    dwain.c (3/26/2015)

    ChrisM@Work (3/26/2015)

    Where’s a plan showing huge Estimated Operator Costs when you need one? Have a look at the estimated plan for this conditional query i.e. the IF as well...

    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 26, 2015 at 6:32 pm

    #1786723

  • RE: SQL Jobs

    sipas (3/26/2015)

    Stewart "Arturius" Campbell (3/26/2015)

    ...i always asked "why" when users wanted development done

    asking that about 5 or 6 times really makes the user think...

    It usually makes them think 'if he...

    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 26, 2015 at 10:08 am

    #1786614

  • RE: Today's Random Word!

    djj (3/26/2015)

    SQLRNNR (3/26/2015)

    pursuit

    Hot

    blooded

    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 26, 2015 at 9:59 am

    #1786607

  • RE: Today's Random Word!

    pursuit

    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 26, 2015 at 9:38 am

    #1786596

  • RE: Are the posted questions getting worse?

    Ed Wagner (3/24/2015)

    SQLRNNR (3/24/2015)

    Brandie Tarvin (3/23/2015)

    Eirikur Eiriksson (3/23/2015)

    GilaMonster (3/23/2015)

    Eirikur Eiriksson (3/22/2015)

    Now where is the Crystal Ball?

    😎

    If you find it, I think this query can only be done if the WITH...

    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 24, 2015 at 3:51 pm

    #1786136

  • RE: sp_MSForEachDB

    Inside your query to be executed you need to change the database in order to change the results. In other words, a use dbname needs to be employed.

    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 24, 2015 at 2:56 pm

    #1786118

  • RE: How Can I Tell the Number of Times People Use SSMS to Change Client Data

    Lowell (3/24/2015)

    ...

    a savvy or nefarious programmer change connection string info, even from SSMS, and send blanks or a fake info.

    Buahaha. Thanks for the idea. 😉

    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 24, 2015 at 7:17 am

    #1785949

  • RE: Database Backup Failure SQL Server 2012 Enterprise

    Anandita Sharma (3/24/2015)

    I am running a split disk backup such as:

    BACKUP DATABASE [At] TO

    DISK = N'O:\sql_bak\At_full1.bak',

    DISK = N'M:\sql_bak\At_full2.bak',

    DISK = N'L:\sql_bak\At_full3.bak' WITH NOFORMAT,

    INIT,

    NAME =...

    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 24, 2015 at 7:15 am

    #1785947

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (3/23/2015)

    Eirikur Eiriksson (3/23/2015)

    GilaMonster (3/23/2015)

    Eirikur Eiriksson (3/22/2015)

    Now where is the Crystal Ball?

    😎

    If you find it, I think this query can only be done if the WITH (CrystalBall) join hint...

    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 24, 2015 at 6:01 am

    #1785924

  • RE: How Can I Tell the Number of Times People Use SSMS to Change Client Data

    You would have to create an audit to capture this kind of data. It is not maintained otherwise.

    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 21, 2015 at 8:37 pm

    #1785538

  • RE: Are the posted questions getting worse?

    Alvin Ramard (3/20/2015)

    Maybe it's time to reboot the server in which life is running.

    Funny. After talking to some friends today after their travel woes.

    After boarding the plane, everybody 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

    March 20, 2015 at 8:04 pm

    #1785493

  • RE: Are the posted questions getting worse?

    spaghettidba (3/20/2015)

    Alvin Ramard (3/20/2015)

    Koen Verbeeck (3/20/2015)

    Alvin Ramard (3/20/2015)

    SQLRNNR (3/20/2015)

    Brandie Tarvin (3/20/2015)

    BWFC (3/20/2015)

    Brandie Tarvin (3/20/2015)

    I'm trying to figure out if this one is real or not. Anyone seen this? (click 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

    March 20, 2015 at 11:41 am

    #1785438

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (3/20/2015)

    BWFC (3/20/2015)

    Brandie Tarvin (3/20/2015)

    I'm trying to figure out if this one is real or not. Anyone seen this? (click the link on the tweet).

    https://twitter.com/petercopters/status/578548234756485120

    It's real alright.

    Wow. Just...

    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 20, 2015 at 11:17 am

    #1785429

Viewing 15 posts - 1,486 through 1,500 (of 19,560 total)