December 9, 2011 at 3:06 am
Evil Kraig F (12/9/2011)
Hulu + Netflix ftw!
Great if you're in the USA....
I don't bother with satellite TV. Too many useless channels and to get the ones I'd be interested in I'd have to pay for the very top contract. Given how little TV I watch, it's a complete waste of money.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 9, 2011 at 3:17 am
SQLRNNR (12/8/2011)
ChrisM@Work (12/8/2011)
SQLRNNR (12/7/2011)
Took the plunge on 70-451Nice one, Jason!
Thanks
Was the braindump useful?:-D
It was just small enough to fit :hehe:
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
December 9, 2011 at 7:14 am
DUH!Code
Code written by an experienced developer that defies all pre-existing code standards and the dev's knowledge skills by believing it can do something the developer knows is impossible.Example: Brandie's code believed it could match on NULL values, even though she knew such a thing was impossible. DUH!
I'm having one of those mornings. Someone save me now.
December 9, 2011 at 7:30 am
Brandie Tarvin (12/9/2011)
DUH!Code
Code written by an experienced developer that defies all pre-existing code standards and the dev's knowledge skills by believing it can do something the developer knows is impossible.Example: Brandie's code believed it could match on NULL values, even though she knew such a thing was impossible. DUH!
I'm having one of those mornings. Someone save me now.
You forgot to post thread url... 😉
December 9, 2011 at 7:34 am
Brandie Tarvin (12/9/2011)
DUH!Code
Code written by an experienced developer that defies all pre-existing code standards and the dev's knowledge skills by believing it can do something the developer knows is impossible.Example: Brandie's code believed it could match on NULL values, even though she knew such a thing was impossible. DUH!
I'm having one of those mornings. Someone save me now.
Heh. Luckily it's Friday 🙂
I developed an SSIS package today and I thought: this will never crash.
It crashed on the first step. :blush:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 9, 2011 at 7:45 am
Brandie Tarvin (12/9/2011)
DUH!Code
Code written by an experienced developer that defies all pre-existing code standards and the dev's knowledge skills by believing it can do something the developer knows is impossible.Example: Brandie's code believed it could match on NULL values, even though she knew such a thing was impossible. DUH!
I'm having one of those mornings. Someone save me now.
I can beat that. I actually just wrote this code and expected it to work. Who's going to be the first to tell me why it doesn't do what I wanted (there are actually 2 reasons...)
DECLARE @StartLetter CHAR(1) = 'A', @EndLetter CHAR(1) = 'Z'
SELECT <stuff> FROM <someTable> WHERE Surname BETWEEN @StartLetter + '%' AND @EndLetter + '%'
Hint: As written that will return rows with surnames Alan, Matthews, White but not Zyl.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 9, 2011 at 7:57 am
GilaMonster (12/9/2011)
Brandie Tarvin (12/9/2011)
DUH!Code
Code written by an experienced developer that defies all pre-existing code standards and the dev's knowledge skills by believing it can do something the developer knows is impossible.Example: Brandie's code believed it could match on NULL values, even though she knew such a thing was impossible. DUH!
I'm having one of those mornings. Someone save me now.
I can beat that. I actually just wrote this code and expected it to work. Who's going to be the first to tell me why it doesn't do what I wanted (there are actually 2 reasons...)
DECLARE @StartLetter CHAR(1) = 'A', @EndLetter CHAR(1) = 'Z'SELECT <stuff> FROM <someTable> WHERE Surname BETWEEN @StartLetter + '%' AND @EndLetter + '%'
Hint: As written that will return rows with surnames Alan, Matthews, White but not Zyl.
Oh, I dunno... Maybe the fact that Zyl sorts *after* Z%? 😛 Been there, written that, laughed at myself afterwards... 🙂
-Ki
December 9, 2011 at 7:58 am
I whacked our movie channels to save $20/mo when we got Netflix streaming. A month later my wife was upset with me. Not enough of a selection for her on Netflix. It seems everything she wanted to watch required a mailing, and 2 days.
I love DirecTV, but then again I tend to watch a 50/50 mix of stupid sitcoms and sports. I'd be fine with sitcoms being a few weeks or months old on Netflix/Hulu, but a fair number of the football/basketball/baseball games aren't available except through some subscription. Plus, I want to be able to flip something one at some random time and watch for 20 minutes.
Personally, I think having the movies starting every hour or so on multiple channels makes sense. Not everyone has DVRs, and even then, not everyone plans ahead. TV is a extra for us, we have time and watch to relax, we we flip it on. We tend not to plan to watch things. Even the few shows we really enjoy, we just record and watch when we can. I find myself 4 or 5 weeks behind on some things.
The exception this year was The Sing Off. We really enjoyed it, and while we recorded it, it was on during vacation and we actually planned to get to the TV to watch it live. First time ever.
December 9, 2011 at 8:14 am
Steve Jones - SSC Editor (12/9/2011)
I whacked our movie channels to save $20/mo when we got Netflix streaming. A month later my wife was upset with me. Not enough of a selection for her on Netflix. It seems everything she wanted to watch required a mailing, and 2 days.I love DirecTV, but then again I tend to watch a 50/50 mix of stupid sitcoms and sports. I'd be fine with sitcoms being a few weeks or months old on Netflix/Hulu, but a fair number of the football/basketball/baseball games aren't available except through some subscription. Plus, I want to be able to flip something one at some random time and watch for 20 minutes.
Personally, I think having the movies starting every hour or so on multiple channels makes sense. Not everyone has DVRs, and even then, not everyone plans ahead. TV is a extra for us, we have time and watch to relax, we we flip it on. We tend not to plan to watch things. Even the few shows we really enjoy, we just record and watch when we can. I find myself 4 or 5 weeks behind on some things.
The exception this year was The Sing Off. We really enjoyed it, and while we recorded it, it was on during vacation and we actually planned to get to the TV to watch it live. First time ever.
Once you get past some recent blockbusters and popular tv shows, Netflix Streaming and Hulu actually have very little content. Fortunately my fiancee is a librarian, so she just gets the movies we want to watch from the library or through inter-library loan and we watch them that way.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
December 9, 2011 at 8:15 am
GilaMonster (12/9/2011)
Brandie Tarvin (12/9/2011)
DUH!Code
Code written by an experienced developer that defies all pre-existing code standards and the dev's knowledge skills by believing it can do something the developer knows is impossible.Example: Brandie's code believed it could match on NULL values, even though she knew such a thing was impossible. DUH!
I'm having one of those mornings. Someone save me now.
I can beat that. I actually just wrote this code and expected it to work. Who's going to be the first to tell me why it doesn't do what I wanted (there are actually 2 reasons...)
DECLARE @StartLetter CHAR(1) = 'A', @EndLetter CHAR(1) = 'Z'SELECT <stuff> FROM <someTable> WHERE Surname BETWEEN @StartLetter + '%' AND @EndLetter + '%'
Hint: As written that will return rows with surnames Alan, Matthews, White but not Zyl.
You're lucky to have a Zyl to test it with! I can imagine that code sitting around for quite awhile on smaller databases before it fails.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
December 9, 2011 at 8:17 am
Kiara (12/9/2011)
Oh, I dunno... Maybe the fact that Zyl sorts *after* Z%? 😛 Been there, written that, laughed at myself afterwards... 🙂
No, that's actually not it...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 9, 2011 at 8:43 am
GilaMonster (12/9/2011)
Kiara (12/9/2011)
Oh, I dunno... Maybe the fact that Zyl sorts *after* Z%? 😛 Been there, written that, laughed at myself afterwards... 🙂No, that's actually not it...
Really? That's what I thought the reason was. . .
BEGIN TRAN
SELECT SUBSTRING('ABCDEFGHIJKLMNOPQRSTUVWXYZ%abc',a.N,1) AS chr
INTO #temp
FROM (VALUES(1),(2),(3),(4),(5),(6),(7),(8),
(9),(10),(11),(12),(13),(14),(15),
(16),(17),(18),(19),(20),(21),(22),
(23),(24),(25),(26),(27),(28),(29),
(30)) a(N)
SELECT chr
FROM #temp
ORDER BY chr
ROLLBACK
Shows that Kiara's assessment is correct, so is there another reason it fails?
December 9, 2011 at 8:46 am
GilaMonster (12/9/2011)
Kiara (12/9/2011)
Oh, I dunno... Maybe the fact that Zyl sorts *after* Z%? 😛 Been there, written that, laughed at myself afterwards... 🙂No, that's actually not it...
Is it that % has no effect in a BETWEEN?
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
December 9, 2011 at 8:50 am
GilaMonster (12/9/2011)
Kiara (12/9/2011)
Oh, I dunno... Maybe the fact that Zyl sorts *after* Z%? 😛 Been there, written that, laughed at myself afterwards... 🙂No, that's actually not it...
I'm sure Gail has something far more obscure up her sleeve.
When I caught myself with almost the same problem awhile back on an ad-hoc query (gotta love those d'oh moments!), it was because I wasn't thinking about the fact that Z% = Z+whatever - which means that < Z% is functionally equivalent to < Z, not < ZZZZZZ...
😉
-Ki
December 9, 2011 at 8:55 am
Kiara (12/9/2011)
GilaMonster (12/9/2011)
Kiara (12/9/2011)
Oh, I dunno... Maybe the fact that Zyl sorts *after* Z%? 😛 Been there, written that, laughed at myself afterwards... 🙂No, that's actually not it...
I'm sure Gail has something far more obscure up her sleeve.
When I caught myself with almost the same problem awhile back on an ad-hoc query (gotta love those d'oh moments!), it was because I wasn't thinking about the fact that Z% = Z+whatever - which means that < Z% is functionally equivalent to < Z, not < ZZZZZZ...
😉
Agreed, I'm looking forward to seeing the real reason it fails - always fun to learn something new! 😀
All I can see is
% < a < A
So the query is will pick out a "name" that contains a single "Z" but will not pick out any "name" that contains any other alphabetic characters because they are all after "%".
Viewing 15 posts - 32,446 through 32,460 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply