Forum Replies Created

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

  • 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

  • RE: Learning to Search

    you should all know about site: searches on search engines

    Amen!

    Knowing how to use the "advanced" search engine features is huge. Anyone in technology (as an example) who took 20 minutes...

    "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 27, 2016 at 10:39 am

    #1892340

  • RE: Clustered Index on Multiple Fields

    the use of every ID column (first 4 columns)

    No column in itself allows to greatly filter the data.

    The users are using the table in various and unmonitored way...

    Not always...

    "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 26, 2016 at 4:43 pm

    #1892167

  • RE: How do you know when it is time to leave a job?

    Rod at work (7/26/2016)

    If, "The market is too starved for talent to be at a job you kinda like or don't like at all.", I don't see any evidence of...

    "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 26, 2016 at 11:33 am

    #1892110

  • RE: Azure SQL Limitations compared with a SQL Server Enterprise

    Nice read, well done Daniel.

    "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 26, 2016 at 8:35 am

    #1892060

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