Forum Replies Created

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

  • 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

  • RE: Query taking time

    PJ_SQL (7/29/2015)

    Hi,

    I have this script, it is taking long time to execute, what can I do to make it execute faster?

    DECLARE @c varchar(10)

    SET @c = '%A1%'

    select *

    from...

    "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

    July 29, 2015 at 10:56 pm

    #1815999

  • RE: Looking for information on SSRS Reports

    Duplicate post - please direct all answers here.

    "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

    July 29, 2015 at 10:37 pm

    #1815998

  • RE: Looking for information on SSRS Reports

    If the reports are being developed using visual studio I would keep a copy of the solution/project and, yes, it would be a good idea to backup the reportserverdb. I...

    "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

    July 29, 2015 at 10:33 pm

    #1815997

  • RE: The Evolving DBA

    There is also the fundamental way in which larger "cloud" type providers (inside your organization or third parties) can include features or services that reduce the need for DBAs.

    I expect...

    "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

    July 23, 2015 at 11:22 am

    #1814473

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