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...

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...

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...

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 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 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...

300 miles (482 KM) from Chicago to Detroit.

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...

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 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)......

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,...

Amen!

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

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...

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...

Nice read, well done Daniel.