Forum Replies Created

Viewing 15 posts - 17,941 through 17,955 (of 59,069 total)

  • RE: Processing strings.

    patrickmcginnis59 10839 (4/4/2016)

    But whatever floats your boat, if you can't see two inches beyond your TSQL experience, the least you could do is admit that separate language linking is at...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 4, 2016 at 12:53 pm

    #1869607

  • RE: DelimitedSplit8K versus DelimitedSplit_Long

    You should also understand that SQL Server deplores joins to the MAX datatypes and doing so usually causes a 2:1 loss in performance to the point where a well written...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 4, 2016 at 9:39 am

    #1869564

  • RE: Code smells versus transgressions

    GPO (4/2/2016)

    :exclamationmark: Storing data in mutli-valued, delimited fields because... Jeez do I have to write another CREATE TABLE statement? Sorry, multivalues are not relational. That's what Pick databases are for.

    It's...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 4, 2016 at 9:32 am

    #1869561

  • RE: Are the posted questions getting worse?

    The cynicism is actually much appreciated and appropriate, IMHO. I especially like your comment about how some games cost as much or more.

    The real fact of the matter is...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 3, 2016 at 1:10 pm

    #1869380

  • RE: Calendar Table Function

    ScottPletcher (3/31/2016)

    Alan.B (3/30/2016)

    Alan.B (3/30/2016)

    ScottPletcher (3/30/2016)

    Alan.B (3/30/2016)

    ScottPletcher (3/30/2016)

    Alan.B (3/29/2016)

    Lastly, ditto the last Thursday of the month:

    SET STATISTICS IO ON;

    PRINT 'Old way:';

    SELECT DISTINCT MAX([Date]) OVER (PARTITION BY [Year],[MonthName],[WeekdayName]) AS [Date]

    FROM ...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 3, 2016 at 10:02 am

    #1869375

  • RE: Are the posted questions getting worse?

    Just in case you may have missed it, there are no longer any excuses. for the many that we try to help and that refuse to help themselves. 🙂 ...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 3, 2016 at 9:42 am

    #1869374

  • RE: Where to start?

    Just to add to the opportunity...

    At the end of March, 2016, Microsoft announced that the Developer's Edition is now FREE! Please see the following URL for details.

    https://blogs.technet.microsoft.com/dataplatforminsider/2016/03/31/microsoft-sql-server-developer-edition-is-now-free/

    Based on a majority...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 3, 2016 at 9:34 am

    #1869373

  • RE: By date

    girl_bj (4/3/2016)

    girl_bj (4/1/2016)

    I manage to run in every 7 days continuously. Added in ROW_NUMBER() OVER (ORDER BY startdate) AS Row too.

    How can I push this record as an output. I...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 3, 2016 at 9:01 am

    #1869372

  • RE: Processing strings.

    Sachin Nandanwar (4/3/2016)

    Jeff Moden (4/2/2016)

    P.S. Please stop posting pictures of code. You can't copy the code from those for test.

    Apologies.I will fix it.

    Again, thank you. That will make...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 3, 2016 at 8:45 am

    #1869370

  • RE: Processing strings.

    Sachin Nandanwar (4/3/2016)

    Jeff Moden (4/2/2016)

    Ah... be real careful about using those test results. I've proven many times that using the same row of data a million times as test...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 3, 2016 at 8:30 am

    #1869369

  • RE: Processing strings.

    Sachin Nandanwar (4/2/2016)

    EDIT: Deleted the code screenshots and replaced it with the actual C# code text.

    You, Sir, are a very good man. Well done and thank you very much.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 3, 2016 at 7:54 am

    #1869366

  • RE: Processing strings.

    P.S. Please stop posting pictures of code. You can't copy the code from those for test.

    Also, instead of using C# to call Visual Basic, stop the tower of Babel...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 2, 2016 at 1:48 pm

    #1869340

  • RE: Processing strings.

    Sachin Nandanwar (4/2/2016)

    Between just stumbled across a very fantastic discussion related to different Split methods for SQL Server.Paul White,Jeff Moden,Aaron Bertrand,Barry Young,Phil Factor(always wondered what his real name is) all...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 2, 2016 at 1:44 pm

    #1869339

  • RE: Help with logic

    On the outside chance that you want the "all or nothing" type of load balancing... please see the following.

    curious_sqldba (4/1/2016)

    I have a table which stores Databasename and sizes. I want...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 2, 2016 at 1:20 pm

    #1869335

  • RE: Help with logic

    curious_sqldba (4/1/2016)

    I have a table which stores Databasename and sizes. I want to be able to assign group numbers to set of database on fly based on there size.

    DBName ...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 2, 2016 at 1:01 pm

    #1869334

Viewing 15 posts - 17,941 through 17,955 (of 59,069 total)