Forum Replies Created

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

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    Something I don't understand:

    SELECT * FROM dbo.DelimitedSplit8K('xxx,d','');

    Returns the whole string. This makes sense, the function found 0 occurrences of the delimiter.

    SELECT * FROM dbo.DelimitedSplit8K(NULL,',');

    Returns a NULL. This makes sense,...

    "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:28 pm

    #1879073

  • RE: Scripts Library

    Lynn Pettis (5/13/2016)

    Actually, yes. I have seen that a couple of script authors have posted scripts in multiple parts but it is difficult to find them since there 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:01 pm

    #1879069

  • RE: Transactional Replication, Log Shipping, Redgate: Getting data from point A to point B without changing the target database design and file system...

    I tried both Transactional Replication and Log Shipping, but both methods end up making the Target database exactly like the Source (e.g. data, table design, and file system).

    That's basically...

    "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:57 pm

    #1879068

  • RE: plan for installation SSRS

    sqlfriends (5/13/2016)

    We are implementing a project and need to setup a new SQL server.

    The server probably will be used only for this project at least now.

    It has database...

    "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:38 pm

    #1879066

  • 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

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