Forum Replies Created

Viewing 15 posts - 16,711 through 16,725 (of 19,560 total)

  • RE: Does a development DBA need to learn dot.net language. ?

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

    #1130747

  • RE: Today's Random Word!

    Twiggy

    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 9, 2010 at 9:37 am

    #1130746

  • RE: Error on TSQL

    WayneS (3/8/2010)

    luissantos (3/8/2010)

    If i write like this :

    select conta, left(dcli.oldesc,charindex('-',dcli.oldesc)-1),dcli.oldesc,

    ltrim(rtrim(conta))+' '+right(ltrim(rtrim(dcli.oldesc)),

    len(ltrim(rtrim(dcli.oldesc)))-(charindex('-',dcli.oldesc)-1)),

    * from dcli where conta <> left(dcli.oldesc,charindex('-',dcli.oldesc)-1)

    I receive the following error:

    Msg 536, Level 16, State 5, Line 2

    Invalid...

    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 9, 2010 at 8:48 am

    #1130717

  • RE: Working the Door

    timeouted (3/9/2010)

    I registered before Jan 15th in order to get the 50% discount from PASS but I didn't have the code at that time.

    I really tried to search for 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 9, 2010 at 8:45 am

    #1130715

  • RE: Working the Door

    Looking forward to the evening.

    Giveaway List (besides the obvious books, cds, dvds, and flash drives)

    Mice

    SUDOKU Cube

    Rubiks Cube

    Kilt

    Pork Chop Bear (Anti-RBAR logo)

    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 9, 2010 at 12:31 am

    #1130477

  • RE: Are the posted questions getting worse?

    Paul White (3/9/2010)

    CirquedeSQLeil (3/8/2010)

    Sorry, I was lost :hehe:

    Now you have it! Though, to be fair, that thread is not the best example...not by a long way.

    ":hehe:" really grates on...

    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 9, 2010 at 12:22 am

    #1130476

  • RE: COUNT_BIG

    Maybe this is a bit nitpicky, but the answer explanation doesn't seem to match the answer.

    The answers are: SELECT COUNT_BIG(*) and SELECT COUNT_BIG(column_2).

    This sentence does not match the correct answers....

    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 9, 2010 at 12:16 am

    #1130473

  • RE: always use incorrect index to run the query by sql server

    Thanks for posting back with your solution.

    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 8, 2010 at 11:53 pm

    #1130462

  • RE: Are the posted questions getting worse?

    Paul White (3/8/2010)

    It's not that I mind people having a go - that's great! It just irks me when the post sounds so authoritative, when it is clearly a...

    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 8, 2010 at 11:51 pm

    #1130461

  • RE: Are the posted questions getting worse?

    Paul White (3/8/2010)

    Lynn Pettis (3/8/2010)

    Paul White (3/8/2010)

    Anyone else noticed the frenzy of poor advice recently? Moderately aggravating.

    Yes, I have. I just hope I haven't been a party 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

    March 8, 2010 at 10:58 pm

    #1130452

  • RE: Too Tipsy To Work

    Lynn Pettis (3/8/2010)

    I got a call from an employer from which I was fired. They paid me $100 per hour, including travel time (3 hours), to come up 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

    March 8, 2010 at 9:34 pm

    #1130416

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/8/2010)

    IT'S OFFICIAL!! Kirisa is now on Varsity! Coach told her today that she earned the position and is now one of his permanent defenders!!

    WAY TO GO...

    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 8, 2010 at 7:30 pm

    #1130378

  • RE: Usage of Database Tuning Advisor

    Yes, I have used DTA in the past. I only use it to see possible recommendations. I do not typically implement changes directly from DTA though. I...

    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 8, 2010 at 5:27 pm

    #1130358

  • RE: Usage of Database Tuning Advisor

    The risk comes in the indexes that it may propose to remove. Any indexes or stats that are recommended are easy to spot and remove.

    As for immediately implementing 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 8, 2010 at 5:14 pm

    #1130355

  • RE: Usage of Database Tuning Advisor

    mohammed moinudheen (3/8/2010)

    I would like to run a workload file on the Database Tuning Advisor(DTA) for getting tuning recommendations.

    There are some batch jobs which are taking more time than usual...

    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 8, 2010 at 5:03 pm

    #1130353

Viewing 15 posts - 16,711 through 16,725 (of 19,560 total)