Forum Replies Created

Viewing 15 posts - 76 through 90 (of 2,462 total)

  • RE: Using Computed Columns

    Good article and great topic. I'm a big fan of computed columns so it's nice to see a detailed article on the topic. I would warn, however, against using 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

    February 12, 2019 at 8:07 am

    #2021778

  • RE: Nasty Fast N-Grams (Part 1): Character-Level Unigrams

    "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

    February 11, 2019 at 12:32 pm

    #2021697

  • RE: Sort already comma separated list

    Jeff Moden - Friday, February 8, 2019 3:27 PM

    Alan.B - Friday, February 8, 2019 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

    February 11, 2019 at 12:26 pm

    #2021696

  • RE: Find and replace third occurrence of the string

    saravanatn - Monday, February 11, 2019 10:09 AM

    Alan.B - Monday, October 22, 2018 3:19 PM

    Just...

    "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

    February 11, 2019 at 12:24 pm

    #2021695

  • RE: Sort already comma separated list

    Jeff Moden - Friday, February 8, 2019 2:09 PM

    jcelko212 32090 - Friday, February 8, 2019 2:04 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

    February 8, 2019 at 2:49 pm

    #2021565

  • RE: Sort already comma separated list

    Jeffrey Williams 3188 - Tuesday, February 5, 2019 12:32 PM

    Jonathan AC Roberts - Wednesday, January 30, 2019...

    "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

    February 5, 2019 at 2:51 pm

    #2021219

  • RE: Any video courses that teach Execution Plans?

    jacob.saugmann - Tuesday, February 5, 2019 10:42 AM

    Hi

    Brent Ozar has a few videoes about the subject https://www.brentozar.com/training/statistics-sql-servers-guessing-game/10-execution-plans-made-10m/ 

    In my opinion the Book written...

    "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

    February 5, 2019 at 11:36 am

    #2021195

  • RE: What it means to atomize values in 1st normal form

    michael.leach2015 - Monday, February 4, 2019 10:50 PM

    Sue_H - Monday, February 4, 2019 9:29 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

    February 5, 2019 at 10:01 am

    #2021184

  • RE: Sort already comma separated list

    PSB - Wednesday, January 30, 2019 7:44 AM

    Hi

    I have values like this in a column which basically is the exact same thing...

    "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

    February 4, 2019 at 12:44 pm

    #2021081

  • RE: Number of employees active per date

    I dont know what table tally is.

    You will after reading this: The "Numbers" or "Tally" Table: What it is and how it replaces a loop

    "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 17, 2019 at 3:10 pm

    #2019289

  • RE: SQL Assignment - Join 2 Tables

    I'm doing a lot of guessing here; moving forward - DDL and sample data will help you get the best answer.  Let's start with this:

    USE tempdb

    "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 17, 2019 at 2:52 pm

    #2019288

  • RE: ssrs 2010 use fx button for inline sql

    Does the reportcurrently use the stored proc or is this a new report? I ask because, if youhave a report that starts with a stored proc but is changed 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

    January 17, 2019 at 2:07 pm

    #2019277

  • RE: How to split comma separated values stored in XML node and display as individual records Without using function- SQL Server 2012

    Lynn Pettis - Wednesday, December 12, 2018 10:22 AM

    Patchai001 - Wednesday, December 12, 2018 10:12 AM
    "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, 2018 at 1:43 pm

    #2016153

  • RE: How to find products commonly purchased together

    This is an fun and interesting problem. If my solution is what you are looking for (or close enough) then I would suggest this index:
    CREATE CLUSTERED INDEX...

    "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

    November 20, 2018 at 12:57 pm

    #2014132

  • RE: Running Concatenation (like running totals)

    etl2016 - Tuesday, October 23, 2018 1:52 PM

    many thanks for the replies.

    The limitations I have is the DB I am working on...

    "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

    October 23, 2018 at 10:18 pm

    #2010882

Viewing 15 posts - 76 through 90 (of 2,462 total)