Forum Replies Created

Viewing 15 posts - 1,291 through 1,305 (of 2,462 total)

  • RE: What are your five most common T-SQL commands

    I made a point at not looking at other people's replies. I use WHOISACTIVE and sp_askbrent quite a bit but that's not what you're looking for. I haven't been doing...

    "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

    August 25, 2015 at 7:50 pm

    #1822370

  • RE: Fine tuning Queries

    Read the article Luis posted.

    Without DDL, sample data there's not much help we can provide. That said, here's a couple bits of advice.

    If you don't need that ORDER...

    "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

    August 20, 2015 at 12:05 pm

    #1821508

  • RE: text mining

    Full text indexing may help but I don't know enough about it or have enough details about your requirement to say for sure. I do have a function, however, which...

    "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

    August 19, 2015 at 11:32 am

    #1821142

  • RE: Collecting contents of a package

    Hey Charmer. I will get back to you tomorrow. (Long day)

    "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

    August 17, 2015 at 10:51 pm

    #1820612

  • RE: Unable to link data from data pulled from XML

    drew.allen (8/17/2015)

    Eirikur Eiriksson (8/14/2015)

    drew.allen (8/14/2015)

    Eirikur Eiriksson (8/14/2015)

    Further, I was only stating that with a properly written XQuery, using the text() function is much quicker, I was not commenting or comparing...

    "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

    August 17, 2015 at 10:47 pm

    #1820611

  • RE: Unable to link data from data pulled from XML

    Eirikur Eiriksson (8/14/2015)

    Alan.B (8/13/2015)

    drew.allen (8/13/2015)

    Alan.B (8/13/2015)

    Just to add to Drew's excellent solution, not only would you want to use the value() method over the query method here, you should include...

    "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

    August 17, 2015 at 10:19 pm

    #1820610

  • RE: The Tally Table

    Jeff Moden (8/14/2015)

    Alan.B (8/14/2015)

    BobAtDBS (8/14/2015)

    I have read Jeff's article, both in the past and an hour ago. His examples aren't things we do at the TSQL level very often....

    "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

    August 17, 2015 at 10:14 pm

    #1820609

  • RE: The Tally Table

    BobAtDBS (8/14/2015)

    I have read Jeff's article, both in the past and an hour ago. His examples aren't things we do at the TSQL level very often. I'm wondering...

    "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

    August 14, 2015 at 3:57 pm

    #1820239

  • RE: The Tally Table

    g.britton (8/14/2015)

    I just wish it wasn't called a "Tally" table. I don't tally things, I count them. fwiw I usually call my "tally" table "N" to reflect it's relation...

    "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

    August 14, 2015 at 9:12 am

    #1820099

  • RE: Unable to link data from data pulled from XML

    drew.allen (8/13/2015)

    Alan.B (8/13/2015)

    Just to add to Drew's excellent solution, not only would you want to use the value() method over the query method here, you should include the text() node...

    "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

    August 13, 2015 at 9:05 pm

    #1819939

  • RE: Getting CPU Core count for licensing

    Take a look at:

    http://basitaalishan.com/2014/01/22/get-sql-server-physical-cores-physical-and-virtual-cpus-and-processor-type-information-using-t-sql-script/%5B/url%5D

    "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

    August 13, 2015 at 2:14 pm

    #1819890

  • RE: Collecting contents of a package

    Charmer (8/13/2015)

    Hi Friends,

    I am trying to collect the metadata of a package in SSIS. What are the securities are needed to collect a metadata of a package?

    since I am testing...

    "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

    August 13, 2015 at 2:04 pm

    #1819882

  • RE: Unable to link data from data pulled from XML

    Just to add to Drew's excellent solution, not only would you want to use the value() method over the query method here, you should include the text() node in your...

    "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

    August 13, 2015 at 1:41 pm

    #1819874

  • RE: Introducing the Set-based Loop

    Great article Luis! 5 Stars sir! I just finished reading it again and it's an excellent article; I can't wait to see more (you are going to write more articles...

    "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

    August 13, 2015 at 12:27 pm

    #1819842

  • RE: The Tally Table

    Also called a numbers table. In addition to the links you posted, Itzek Ben-Gan has writes about numbers tables in his books and articles.

    Jeff Moden once said in...

    "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

    August 12, 2015 at 11:26 pm

    #1819550

Viewing 15 posts - 1,291 through 1,305 (of 2,462 total)