Forum Replies Created

Viewing 15 posts - 721 through 735 (of 2,462 total)

  • 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

  • RE: Beginner Help

    Off the top of my head...

    If you are interested in SQL Development then maybe consider learning about/creating stored procedures and functions.

    If you are interested in the database administration...

    "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 10:38 am

    #1878313

  • RE: New index not used but query slowed down

    As Eirikur suggested, actual (not the estimated ones) execution plans would be helpful. I suspect that this has something to do with bad/out-of-date statistics.

    "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:20 am

    #1878252

  • RE: Simple SQL challenge - who can solve

    I'd like to pile on and say a Tally Table is the best performing and most simple solution.

    That said, another high-performing and very simple solution would be one that...

    "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:15 am

    #1878249

  • RE: Merge Replication

    Brandie Tarvin (5/11/2016)

    Alan.B (5/11/2016)

    I last did any real replication in SQL Server 2008 but you can do merge in this scenario. You could also have a mix of snapshot and/or...

    "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:02 am

    #1878240

  • RE: Query Help

    No problem.

    "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 7:36 am

    #1878225

  • RE: Merge Replication

    Brandie Tarvin (5/11/2016)

    dastagiri16 (5/10/2016)

    Can we configure Merge Replication ..

    Like sever A(publisher) - server b(subscriber) and sever b(publisher) to server C(subscriber) ?

    The only way to know is to try it. But...

    "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 7:19 am

    #1878211

  • RE: Urgent! - How to extract number from a string

    initials_mi (9/18/2014)

    I came across the same situation and I found the working solution for it.

    Here is the link:

    http://www.ittutorials.in/source/sql/sql-function-to-extract-only-numbers-from-string.aspx

    A set-based solution that does not use a loop is the faster way...

    "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 7:01 am

    #1878167

  • RE: Split string and insert to table

    You can accomplish this using DelimitedSplit8K, note the "splitter" referenced in my signature. You would split the user column using the pipe "|" as your delimiter. Post back if 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 11, 2016 at 6:36 am

    #1878136

  • RE: XQuery help

    This is probably the best sub forum to post this question provided you are running SQL 2012. There's also an XML sub forum but, since this is a SQL/XML question...

    "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 10, 2016 at 7:55 pm

    #1878027

  • RE: Query Help

    To quote Ned Flanders from the Simpsons, "As melon scratchers go, this one's a real honeydoodle."

    There's a better solution out there and I have a few ideas how to speed...

    "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 10, 2016 at 7:27 pm

    #1878024

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

    If you are on 2014 you don't want 2008 execution plans. 2014 has a new cardinality estimator. If you have time to update your version of SQL then you should...

    "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 10, 2016 at 5:16 pm

    #1878015

Viewing 15 posts - 721 through 735 (of 2,462 total)