Forum Replies Created

Viewing 15 posts - 706 through 720 (of 2,458 total)

  • RE: Code Review

    Maybe someone else will dig through your code but after 64 visits and 42 posts I'm sure you've heard the lecture about DDL and consumable data. Not providing that makes...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 13, 2016 at 7:24 pm

    #1879064

  • RE: Are the posted questions getting worse?

    I posted a couple thoughts about Spam - I was wondering what other people's thoughts were:

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 13, 2016 at 9:16 am

    #1878941

  • RE: Sad to see spamming being flooded in this forum.

    And why is this a SQL2012 thread?

    Haha - my first good laugh of the day.

    My thought on this is that it's a SQL related problem (people who unwanted records are...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 13, 2016 at 8:48 am

    #1878924

  • RE: Join Operations – Hash Match

    I just read this for the first time this morning. Very informative and we'll written. Great work Jason.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 13, 2016 at 5:21 am

    #1878866

  • RE: T-SQL Equivalent to Oracle TRANSLATE

    Forgive me for reviving an 8 year old forum but here's a brand new, well tested and high-performing translate function: Translate8K[/url]

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 12, 2016 at 5:46 pm

    #1878807

  • RE: Import Execution Plans of SQL 2008 to SQL 2014

    Hard to say... I am assuming this is a Production environment, correct? If so, why not try this in a Dev environment first? Why not run through this a...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 12, 2016 at 5:34 pm

    #1878806

  • RE: Rows duplicating for each person

    Hello and welcome to SSC. Please note the link in my signature line for the best way to get help here. If you can include the DDL for the tables,...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 12, 2016 at 11:53 am

    #1878737

  • RE: Are the posted questions getting worse?

    Chad Crawford (5/12/2016)

    I think of certifications as one leg on a four legged stool. The other three legs are experience, education and community (blog/forum/twitter/etc.). If you only have one...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 12, 2016 at 10:41 am

    #1878723

  • RE: Are the posted questions getting worse?

    I seem to have misplaced the crystal ball. Anyone want to look at this: http://www.sqlservercentral.com/Forums/Topic1785774-392-1.aspx#bm1785786

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 12, 2016 at 9:34 am

    #1878705

  • RE: Query to compare two views and find non-matching record ??

    rk1980factor (5/12/2016)

    any help will be great??

    I think what ChrisM posted should help you.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 12, 2016 at 8:37 am

    #1878688

  • RE: query help needed

    Can you post what the desired output should look like?

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 12, 2016 at 8:31 am

    #1878684

  • RE: Split string and insert to table

    I'm using a temp variable so you can easily copy/paste this code and run it locally. Note that you need to have delimitedsplit8K created for this to work.

    DECLARE @cap2 TABLE...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 11, 2016 at 8:51 pm

    #1878424

  • RE: Simple SQL challenge - who can solve

    drew.allen (5/11/2016)

    Alan.B (5/11/2016)

    drew.allen (5/11/2016)

    Actually, an inline table-valued function based on a table value constructor (like in Luis' script above) is blazing fast. Much faster than any physical table, because...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 11, 2016 at 8:34 pm

    #1878421

  • RE: Simple SQL challenge - who can solve

    drew.allen (5/11/2016)

    Eric M Russell (5/11/2016)

    TheSQLGuru (5/11/2016)

    Eric M Russell (5/11/2016)

    drew.allen (5/11/2016)

    Eric M Russell (5/11/2016)

    For what it's worth, this one can be paramaterized in terms of the number of dates returned, and...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 11, 2016 at 3:17 pm

    #1878402

  • RE: Simple SQL challenge - who can solve

    Now that I'm at a computer....

    Not knocking Luis' solution but calendar tables are perfect for this kind of thing as they are highly reusable and even more simple than a...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    May 11, 2016 at 1:04 pm

    #1878369

Viewing 15 posts - 706 through 720 (of 2,458 total)