Viewing 15 posts - 196 through 210 (of 262 total)
Thanks, great example of how to compare efficiency of various options! 🙂 Glad to see that the most straightforward ("LIKE") is also basically the fastest.
March 6, 2014 at 9:01 am
Thanks much for the reply. Unfortunately it's a shared server, so we don't have access to full-text indexing or other special settings.
And yes, I am going to use some...
March 5, 2014 at 8:53 am
What if it's down for more than 24 hours? How can you tell with no dates?
February 25, 2014 at 2:03 pm
What do you need help with? Designing your database tables? Or writing code to parse IMDb? The latter would be beyond the scope of a database. The former we can...
February 25, 2014 at 11:29 am
I may be stupid and just missing something obvious, but I don't see where you're storing dates at all. You're only storing time and day of the week. So how...
February 25, 2014 at 11:20 am
T-SQL does not have a native BetaDist function. You can buy statistical packages/add-ons that include it, but one that I looked at was $600.
I'm not a statistics wizard, so...
February 25, 2014 at 11:13 am
I actually didn't know you could use BETWEEN in this way, for (var)char datatypes. And without the wildcard % operator. Groovy.
February 25, 2014 at 10:42 am
I can't rival the other guys on this board, but I am using this as practice for myself and would like (constructive but friendly) feedback on the solution I came...
December 6, 2013 at 1:15 pm
Perhaps "wizardry" would have been more appropriate, but I had a little alliteration thing going there with the "t's", so... 🙂 I'm certainly in awe of you cats and your...
November 25, 2013 at 6:00 pm
I knew it'd just be a matter of time before someone posted some Cartesian tally table trickery. 🙂
November 25, 2013 at 4:25 pm
This might be too low budget a solution for you, but what if you simply created another table that had every possible date in it? Then it would simply be...
November 25, 2013 at 11:18 am
Yeah, honestly I'm not clear on the specifics of it either. But conceptually I understand what it does, and this seems to fit the bill AFAIK... I hope you'll report...
November 15, 2013 at 1:13 pm
I think Sean was unclear on the specific failure you were encountering, not unclear on the phrase "where filter". No need to be snippy.
November 15, 2013 at 1:07 pm
Would UNPIVOT possibly be helpful in this type of scenario?
November 15, 2013 at 1:02 pm
Viewing 15 posts - 196 through 210 (of 262 total)