## Forum Replies Created

Viewing 15 posts - 16 through 30 (of 423 total)

• ### RE: Curious Case of SUM Function

thisisfutile - Thursday, August 31, 2017 12:32 PM

Great article!  I learned something from this so thank you for posting.  My takeaway is...

• ### RE: Graphing Performance

The article referenced in Steve's writing is completely biased and unfair in my opinion.  Graph databases are for graph data but the data used in the study was simple two...

• ### RE: Finding Consecutive Values For a Record

The problem is the denormalized table.  Create a view that has four columns for the  ID, Year, Month, and Value.  Then, write a simple query against the view.

• ### RE: The Career Bucket List

A bucket list strikes me as odd since it has an internal to external direction.  I've always been intuitively listening to the universe instead of talking to it.  Several years...

• ### RE: Curious Case of SUM Function

Notice that even when the scale is > 0 for both the changed behavior may still appear.  It depends on the Precision.

-- 18,2 and 18,3

• ### RE: Potential presentation idea: What a cookbook can teach us about programming

Schools use Logo to teach programming since it is interpreted and very visual.  Logo has grown up into a systems simulator but is still very useful as a high school...

• ### RE: CASE expression in GROUP BY clause

Personally, I would create an exceptions table to be joined to your main query.  It would make your code cleaner. Try something like this and left join to it:
Declare...

• ### RE: Potential presentation idea: What a cookbook can teach us about programming

Effective teaching methods is an extremely complex subject and hotly debated. A cookbook is a simple algorithm with a subset of programming constructs so it is a start. ...

• ### RE: Altering SSMS script templates

If you have an open query in SSMS, you can select a table name or any word and hit a Query ShortCut key to run a custom command which will...

• ### RE: Fuzzy Search

dlchase - Friday, August 4, 2017 7:39 AM

Thanks. BTW I love the function for many of my searches!  I will try some...

• ### RE: Fuzzy Search

dlchase - Friday, August 4, 2017 7:01 AM

I was hoping to find something that would return matches on similar names but this...

• ### RE: Fuzzy Search

J Livingston SQL - Thursday, August 3, 2017 11:01 AM

any links to code/data sources to generate this 1 million row "Names" table...

• ### RE: Fuzzy Search

Kimberly Blum - Thursday, August 3, 2017 9:04 AM

While this is very useful for returning a list to be examined manually, it's...

• ### RE: Fuzzy Search

Sergiy - Thursday, August 3, 2017 6:09 AM

Did you try it for pairs like
"UCLA" <--> "University of California Los Angeles" ?
What kind...

• ### RE: Fuzzy Search

lauri.pietarinen - Thursday, August 3, 2017 5:18 AM

There has actually been some research on this approach,  see for instance: