Forum Replies Created

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

  • RE: Powershell script to find the text between two strings

    If you have some basic SQL and XML knowledge you can use SQLXML to query the packages for the ConnectionManager. ConnectionManger Info lives in DTS:ConnectionManger. 
    For example, if 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

    April 14, 2017 at 3:41 pm

    #1938235

  • RE: query puzzle

    Yes, loops bad. Set-based good. 

    First for some sample data:
    IF OBJECT_ID('tempdb..#stu') IS NOT NULL DROP TABLE #stu;
    CREATE TABLE #stu(nid int NULL, student_name varchar(100) NOT NULL);

    "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 14, 2017 at 3:17 pm

    #1938230

  • RE: Selecting all text between a distinct path

    I'm a little late here but I have a function that is designed for exactly this type of thing. If you grab a copy on NGrams8k you could create...

    "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 14, 2017 at 2:56 pm

    #1938226

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

    AnthonyR - Tuesday, April 11, 2017 11:44 PM

    Jeff Moden - Tuesday, April 11, 2017 8:42 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

    April 12, 2017 at 8:31 am

    #1937857

  • 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

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