Forum Replies Created

Viewing 15 posts - 286 through 300 (of 2,458 total)

  • RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    Hugo Kornelis - Tuesday, April 11, 2017 2:59 PM

    david.holley - Tuesday, April 11, 2017 11:27 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

    April 11, 2017 at 6:49 pm

    #1937743

  • RE: 'Spell check' a string-valued field

    Jeff Moden - Friday, March 31, 2017 7:35 AM

    Alan.B - Thursday, March 30, 2017 8: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

    March 31, 2017 at 3:06 pm

    #1936084

  • RE: What do you do to relax after work?

    I became a father a nearly two years ago. What does relax mean again? 

    My daughter love Jimi Hendrix so sometimes we kick back and watch rare Hendrix videos...

    "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

    March 30, 2017 at 9:10 pm

    #1935899

  • RE: 'Spell check' a string-valued field

    I don't know if what Jeff posted was helpful (another vanishing OP) but this is certainly doable. You need to do two things:
    (1) Extract the element names 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

    March 30, 2017 at 8:49 pm

    #1935898

  • RE: How to load and in what order warehouse tables

    When designing a star schema the first two questions you need to answer are:
    1. What does the customer want to measure?
    2. How do they want to measure...
    "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

    March 30, 2017 at 5:57 am

    #1935685

  • RE: Starting with Full Text Search: Suggested links ...

    ash304 - Wednesday, March 29, 2017 9:06 PM

    Hi Alan,

    Thanks for the pointer to FileTables and the link to get started.

    As of now,...

    "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

    March 29, 2017 at 9:43 pm

    #1935632

  • RE: Search for string in stored procedures excluding comments

    Spinja - Wednesday, March 29, 2017 2:51 PM

    I needed a similar solution. I liked Lowell's clever use of the STUFF function (thanks)....

    "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

    March 29, 2017 at 6:11 pm

    #1935625

  • RE: Menaing of the select statement

    That SELECT statement is not valid, it needs one more right-parenthesis . This correct syntax for that SELECT statement:
    SELECT CAST(MAX(ISNULL(AlterDate,CRDate)) as DATE)

    This would be 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

    March 29, 2017 at 8:12 am

    #1935500

  • RE: Starting with Full Text Search: Suggested links ...

    ash304 - Tuesday, March 28, 2017 9:24 PM

    Hi Alan,

    Thanks a lot for these links. They both look good! I will spend some...

    "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

    March 29, 2017 at 7:50 am

    #1935494

  • RE: Starting with Full Text Search: Suggested links ...

    ash304 - Tuesday, March 28, 2017 6:27 PM

    Hi Grant, 

    Sorry to make you a bit nervous 🙂
    No, it is not your book!

    I have...

    "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

    March 28, 2017 at 7:32 pm

    #1935414

  • RE: SQL Server primary key on float data type

    I meant float (53) IS 8 bytes (...and can't figure out how to edit using the new forum format.)

    "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

    March 28, 2017 at 12:42 pm

    #1935365

  • RE: SQL Server primary key on float data type

    The direct answer is NO. Float (53) is not 8 bytes and imprecise as has already been mentioned. Another problem is that, although, your existing data is int, using float...

    "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

    March 28, 2017 at 11:07 am

    #1935325

  • RE: SELECT @local_variable '=' Versus SELECT @local_variable '+='

    No problem. Glad to help.

    "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

    March 23, 2017 at 3:54 pm

    #1934668

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson - Thursday, March 23, 2017 3:12 AM

    Anyone with an iPhone and iCloud should have a look at 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

    March 23, 2017 at 10:57 am

    #1934572

  • RE: Load data in chunks daily

    jonas.gunnarsson 52434 - Thursday, March 23, 2017 7:36 AM

    may be the following can help
    importing large SQL files

    That link is for...

    "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

    March 23, 2017 at 8:21 am

    #1934520

Viewing 15 posts - 286 through 300 (of 2,458 total)