Forum Replies Created

Viewing 15 posts - 556 through 570 (of 2,462 total)

  • RE: Count the occurrence of word in a Resume Table

    shambhavi13 (8/9/2016)

    Yeah no doubt the below solution you gave is the fastest of all .. but after testing it on few resumes it doesn't seem to give exact count ..

    SELECT...

    "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

    August 10, 2016 at 8:54 am

    #1894814

  • RE: Full-Text Indexing & Searches

    Alternatively you could parse those strings into individual words and create a search table that would avoid the scan problem, but that is probably a lot more work than 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

    August 9, 2016 at 9:34 pm

    #1894698

  • RE: Count the occurrence of word in a Resume Table

    .. I want to display the candidate rank as an avg of all the three columns .

    Using my sample data from earlier, the best way would be like so:

    SELECT...

    "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

    August 8, 2016 at 10:03 pm

    #1894457

  • RE: Count the occurrence of word in a Resume Table

    J Livingston SQL (8/4/2016)

    ALan....consider the following please

    DECLARE @tblResumeTag TABLE ( int identity primary key, TextVersion varchar(8000));

    INSERT @tblResumeTag(TextVersion) VALUES

    ('I accelerated the development of the system by making rationale decisions based 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

    August 8, 2016 at 9:27 pm

    #1894455

  • RE: Count the occurrence of word in a Resume Table

    Dixie & J Livingston, sorry for the late reply - I had a rough weekend with a sick family (we're all sick).

    The Dixie Flatline (8/4/2016)

    I've read the Nasty Fast N-Grams...

    "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

    August 8, 2016 at 9:07 pm

    #1894454

  • RE: Count the occurrence of word in a Resume Table

    Also, with respect to the N-grams. All you are asking for is unigrams (in your example, individual words), and the rest of it is probably beyond the scope of 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

    August 4, 2016 at 11:02 am

    #1893888

  • RE: Variable Declaration Failure

    The way Eirikur does it is my preference too; no reason for a SET statement if you know the value of the variable when you declare it.

    To expand 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

    August 4, 2016 at 8:04 am

    #1893785

  • RE: Count the occurrence of word in a Resume Table

    shambhavi13 (8/3/2016)

    I have a table called Resume with columns in Text, Word and PDF format. I enabled Full Text Search on the table and able to search the keyword through...

    "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

    August 4, 2016 at 7:16 am

    #1893766

  • RE: What title would you look for......

    I would say Data warehouse developer.

    Titles in the data world are not very informative. I've had each of these job titles at multiple companies: DBA, BI Developer, and, in...

    "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

    August 3, 2016 at 9:09 pm

    #1893661

  • RE: Find all 35 combinations in 7 numbers ?

    I think Andrew (Happy Geek) hit the nail on the head. Assuming that there are 5 dates/rows total there should be a total of 35 number/date combinations.

    Taking Andrew's test...

    "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

    August 3, 2016 at 9:03 pm

    #1893660

  • RE: How Far Have You Traveled for a SQL Saturday?

    300 miles (482 KM) from Chicago to Detroit.

    "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

    August 3, 2016 at 10:15 am

    #1893549

  • RE: Clustered Index on Multiple Fields

    Sorry - late, started a few times and got pulled away. I'll try to reply to Kevin's statement and Vince's question.

    First, I have to reiterate my suggestion that 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

    August 3, 2016 at 9:02 am

    #1893520

  • RE: SQL Server 2016 Justification

    The benefits of upgrading from 2008 to 2016 are cumulative. SQL Server 2012 was a huge upgrade from 2008. On the T-SQL side you have:

    * LAG/LEAD - super...

    "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

    July 29, 2016 at 3:16 pm

    #1892727

  • RE: Get DDL for any SQL 2005 table

    I just ran across this Lowell, it was exactly what I was looking for and has saved me a lot of time (it's 8:50PM in Chicago and I'm still working)......

    "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

    July 28, 2016 at 7:51 pm

    #1892565

  • RE: Are the posted questions getting worse?

    Lynn Pettis (7/28/2016)

    Brandie Tarvin (7/28/2016)

    ChrisM@Work (7/28/2016)

    BrainDonor (7/28/2016)

    I would like to know why they even bother.

    How many people out there are going to think "I could do with a new kitchen,...

    "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

    July 28, 2016 at 7:03 am

    #1892464

Viewing 15 posts - 556 through 570 (of 2,462 total)