Forum Replies Created

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

  • 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

  • RE: Find and replace third occurrence of the string

    Just for fun I thought I'd throw in a solution that leverages NGrams8k. This will likely be a little slower than what Jason posted but it parallelizes nicely...

    "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 22, 2018 at 3:19 pm

    #2010697

  • RE: Running Concatenation (like running totals)

    You can do this on SQL Server 2005+ like so:

    -- Your Data
    DECLARE @table TABLE(ColA INT, ColB CHAR(1), RowNumber INT);
    INSERT @table(ColA,ColB,RowNumber)
    SELECT ColA,ColB,RowNumber
    FROM (VALUES

    "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 22, 2018 at 2:14 pm

    #2010690

  • RE: SQL Server Default Constraints can be constants, functions or objects. What kind of objects other than functions?

    gbritton1 - Thursday, October 4, 2018 7:02 AM

    Alan.B - Wednesday, October 3, 2018 3:40 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

    October 4, 2018 at 7:43 am

    #2008051

  • RE: SQL Server Default Constraints can be constants, functions or objects. What kind of objects other than functions?

    gbritton1 - Wednesday, October 3, 2018 7:28 AM

    What kind of objects may be specified, other than constants or functions?

    They worded this BOL...

    "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 3, 2018 at 3:40 pm

    #2007981

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