Forum Replies Created

Viewing 15 posts - 151 through 165 (of 2,458 total)

  • RE: IN-Memory tables

    Not a complete list but some highlights...

    Pro's:
    1. Can be faster than on-disk tables because of there's no IO cost.
    2. A bonus benefit of 2016 vs...

    "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

    January 7, 2018 at 5:16 pm

    #1974843

  • RE: A Brief History of Data Analysis

    Great article, very well done. You completely skipped over the era of magnetic tapes but I won't hold it against 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

    January 4, 2018 at 6:21 pm

    #1974605

  • RE: Views and Collations

    shindle 17293 - Thursday, January 4, 2018 5:56 PM

    Thanks for the reply.

    Can this be done for a whole table within a view...

    "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

    January 4, 2018 at 6:16 pm

    #1974604

  • RE: SHREDDING XML - Can it be done quickly?

    This is running much slower for you than it should. Your query is instantaneous on my laptop as well. I even created 10K rows of sample data and tested it. This...

    "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

    December 27, 2017 at 2:17 pm

    #1973633

  • RE: Is the old stuff worth learning?

    I remember reading DOS for Dummies in 1996 (studying for the A+ exam) and, in it, there is a discussion about how DOS is never going away. I thought the...

    "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

    December 26, 2017 at 9:32 am

    #1973478

  • RE: PRIME NUMBERS

    Jason A. Long - Wednesday, December 13, 2017 2:18 PM

    Jeff Moden - Wednesday, December 13, 2017 5:27...

    "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

    December 13, 2017 at 5:36 pm

    #1972054

  • RE: Today's Random Word!

    Ray K - Wednesday, December 13, 2017 3:00 PM

    ManicStar - Wednesday, December 13, 2017 2:49 PM
    "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

    December 13, 2017 at 4:01 pm

    #1972052

  • RE: Indexed views versus filtered indexes

    It Depends.

    It depends on how you're querying these tables, how you're joining them, what kinds of Aggregations you're performing, how your data is partitioned and stuff like 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

    December 13, 2017 at 12:10 pm

    #1972010

  • RE: Importing XML in SQL Table

    I don't use OPENXML often but knowing XPath makes this sort of thing pretty easy.  Here I'm using a variable for the XML so that you can copy/paste...

    "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

    December 13, 2017 at 11:49 am

    #1972002

  • RE: Looking for an optimal solution

    aaron.reese - Wednesday, December 13, 2017 7:50 AM

    Fells like a job for PIVOT to me.
    You say that the number of tests is...

    "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

    December 13, 2017 at 8:34 am

    #1971971

  • RE: Looking for an optimal solution

    DesNorton - Tuesday, December 12, 2017 11:09 PM

    Alan.B - Tuesday, December 12, 2017 3:01 PM

    "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

    December 12, 2017 at 11:23 pm

    #1971883

  • RE: Looking for an optimal solution

    flownominal16 - Tuesday, December 12, 2017 3:08 PM

    ScottPletcher - Tuesday, December 12, 2017 2:50 PM

    "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

    December 12, 2017 at 3:14 pm

    #1971850

  • RE: Looking for an optimal solution

    flownominal16 - Tuesday, December 12, 2017 1:58 PM

    Hey all -

    Thanks for the interest.  Unfortunately, my scenario is rigidly as described as far...

    "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

    December 12, 2017 at 3:01 pm

    #1971846

  • RE: Advice for Newcomers

    Do what you love and the money will come; nobody is awesome at stuff they don't like to do - regardless of how well it pays. 

    This has been...

    "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

    December 12, 2017 at 1:51 pm

    #1971838

  • RE: Looking for an optimal solution

    What are you trying to do?

    "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

    December 12, 2017 at 1:40 pm

    #1971835

Viewing 15 posts - 151 through 165 (of 2,458 total)