Forum Replies Created

Viewing 15 posts - 5,881 through 5,895 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    Lynn Pettis (7/26/2012)

    Brandie Tarvin (7/26/2012)

    WayneS (7/26/2012)

    You'll might find this interesting: http://www.sqlperformance.com/2012/07/t-sql-queries/split-strings

    Very interesting indeed. Poor Jeff. Poor Tally Tables.

    Did you take a close look at how Jeff's split routine was modified?...

    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 26, 2012 at 1:25 pm

    #1518147

  • RE: Keeping users out of SA password

    Jeff Moden (7/25/2012)

    Mark R1 (7/23/2012)

    This is a poorly done saas implementation that another company is hosting, I have been locking down individual logins, but that does no good unless 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

    July 26, 2012 at 12:33 pm

    #1518120

  • RE: Contained Databases

    Thanks Wayne - I had to check BOL to be certain.

    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 26, 2012 at 12:27 pm

    #1518119

  • RE: Today's Random Word!

    opc.three (7/26/2012)

    Daniel Bowlin (7/26/2012)

    Begin

    TRY

    catch

    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 26, 2012 at 10:54 am

    #1518062

  • RE: Are the posted questions getting worse?

    Jeff Moden (7/25/2012)

    Please join me in reporting this and all other posts of this nature by this person. This has got to stop. If anyone of us made...

    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 25, 2012 at 8:06 am

    #1517373

  • RE: any better way of doing this Query

    Nice work Chris and Cadavre.

    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 25, 2012 at 8:05 am

    #1517371

  • RE: Rename column

    sestell1 (7/25/2012)

    Thanks for the question!

    I don't use computed columns often, so this is very good to know!

    +1

    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 25, 2012 at 8:01 am

    #1517368

  • RE: Database Mail is NOT supported in 2012 Standard Edition x64!

    We had this discussion in another thread recently. And yes, the end result (with different documentation) was that it was a documentation error.

    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 24, 2012 at 2:25 pm

    #1517071

  • RE: Rename the existinng File at same location

    Jeff Moden (7/24/2012)

    Heh... I suppose that's a reason to dislike XML more than SSIS. And, I do. 🙂

    Couldn't agree more. There are some tricks to learn along the way...

    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 24, 2012 at 2:20 pm

    #1517069

  • RE: Calculate Past Due Principal and Past Due Interest Based on Due Dates

    I think a fair amount more information would be useful for this thread. There are different terms, interest rates, methods of applying and calculating interest, penalties, fees etc that...

    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 24, 2012 at 12:34 pm

    #1517024

  • RE: Today's Random Word!

    Ray K (7/24/2012)

    Ichiro

    (says the happy Yankee fan this morning!)

    There goes another great ball player I can no longer cheer for :sick:

    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 24, 2012 at 12:31 pm

    #1517021

  • RE: Order of Execution

    Jamsheer (7/23/2012)

    Thanks for the easy point.. I think the first and last options given are same..

    They were the same. Made it a bit easier 😉

    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 24, 2012 at 12:29 pm

    #1517019

  • RE: Modifying Column Size

    What is the tsql you used to make the change? Are you dumping the table into a temp table and then renaming that temp table and replacing the actual...

    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 24, 2012 at 10:10 am

    #1516935

  • RE: T-SQL (Proc) Conversion to SSIS!

    Forgot to mention, the credit card charging was to use soap requests across the internet. I am curious if the CC charging you have done is similar or different.

    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 23, 2012 at 9:13 pm

    #1516564

  • RE: T-SQL (Proc) Conversion to SSIS!

    Yes. XML Source

    http://msdn.microsoft.com/en-us/library/ms140277.aspx

    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 23, 2012 at 9:11 pm

    #1516563

Viewing 15 posts - 5,881 through 5,895 (of 19,560 total)