Forum Replies Created

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

  • 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

  • RE: how to count number of student

    For this you would use GROUP BY.

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

    #1878012

  • RE: Merge Replication

    I can't see why not.

    "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 1:54 pm

    #1877966

  • RE: single xml to multiple rows

    squvi.87 (5/9/2016)

    Hi There,

    I require to convert single xml into multiple rows, as explained below

    Thanks in advance

    In the future try to include the actual XML (or table data) instead of 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 10, 2016 at 9:47 am

    #1877879

  • RE: Talking baseball

    calvo (5/9/2016)

    Alan.B (5/5/2016)

    And 2003 with the infamous "Bartman ball". Being a Cubs fan is as painful as it gets but it will be worth it if they even get to...

    "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 9:06 am

    #1877831

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