December 9, 2011 at 12:59 pm
Koen Verbeeck (12/9/2011)
I recently moved to a new house and I took the opportunity to get me and my family digital television (it's fairly "new" in Belgium).So now I have access to over more than 200 channels. Can you believe I still have the feeling that nothing is on? :ermm:
I guess TV inBelgium must be very like TV in Britain - more than a hundred channels and nothing on is something I am used to having when in Britain.
Tom
December 9, 2011 at 1:05 pm
L' Eomot Inversé (12/9/2011)
Koen Verbeeck (12/9/2011)
I recently moved to a new house and I took the opportunity to get me and my family digital television (it's fairly "new" in Belgium).So now I have access to over more than 200 channels. Can you believe I still have the feeling that nothing is on? :ermm:
I guess TV inBelgium must be very like TV in Britain - more than a hundred channels and nothing on is something I am used to having when in Britain.
The US isn't that different. Why do you think we're importing the British shows?! :w00t:
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 9, 2011 at 1:14 pm
GilaMonster (12/9/2011)
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.
Too many useless channels - same everwhere (and many of the most useless channels have a +1 channel that repeats their junk an hour later). But I went for satellite because the BBC Alba channel (the only UK TV channel in my language) isn't broadcast on digital terrestrial in England, and BBC Radio nan Gaidheal isn't on terrestrial radio in England either. Fortunately for me they are both in the Freesat package.
Tom
December 9, 2011 at 1:18 pm
L' Eomot Inversé (12/9/2011)
GilaMonster (12/9/2011)
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.
Too many useless channels - same everwhere (and many of the most useless channels have a +1 channel that repeats their junk an hour later). But I went for satellite because the BBC Alba channel (the only UK TV channel in my language) isn't broadcast on digital terrestrial in England, and BBC Radio nan Gaidheal isn't on terrestrial radio in England either. Fortunately for me they are both in the Freesat package.
Actually, I can see the advantage of that +1 channel, if I stumble across a movie I wanted to see and it's less than an hour in, I can flip and catch it from the start.
Not that I watch live TV anymore, DVR + Netflix FTW! Haven't tried Hulu, is it worth it for current shows like The Middle/Modern Family? Our local cable company is in a dispute with ABC/FOX, so we might lose some of the shows we usually DVR...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
December 9, 2011 at 10:01 pm
Hmmm. I think I just found a bug in SQL 2012 - one of the new Analytic functions returns a different value when called from within a cte. Anyone willing to test it to verify it? Please PM me, and I'll send sample code.
Edit: Just posted a Connect bug for this, which has the code to reproduce (requires AdventureWorks2008R2 database from the CodePlex Denali download). Please go vote this up so it can get fixed before RTM.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
December 9, 2011 at 11:05 pm
WayneS (12/9/2011)
Edit: Just posted a Connect bug for this, which has the code to reproduce (requires AdventureWorks2008R2 database from the CodePlex Denali download). Please go vote this up so it can get fixed before RTM.
The CTE example should strictly have the ORDER clause inside the CTE (so it applies to the TOP) to be semantically the same. Does look like a bug though, at least on first look. Also reproduces if you use a subquery rather than a CTE. Might be missing something here though (analytic function query plans are a nightmare) so going to play around a bit before voting/commenting there.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
December 9, 2011 at 11:50 pm
Wayne,
Still digging into the details, but this is a much-simplified repro:
DECLARE @Example TABLE
(
order_date DATE NOT NULL,
total_due MONEY NOT NULL
)
INSERT @Example
VALUES
('2001-01-01', $1.00),
('2002-01-01', $2.00),
('2003-01-01', $3.00)
SELECT
first_date =
FIRST_VALUE(order_date) OVER (
ORDER BY total_due
ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING),
last_date =
LAST_VALUE(order_date) OVER (
ORDER BY total_due
ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING)
FROM @Example
;
WITH SQ1 AS
(
SELECT
first_date =
FIRST_VALUE(order_date) OVER (
ORDER BY total_due
ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING),
last_date =
LAST_VALUE(order_date) OVER (
ORDER BY total_due
ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING)
FROM @Example
)
SELECT * FROM SQ1
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
December 10, 2011 at 12:08 am
Turns out the parser is sending 'range between unbounded and current' for both FIRST_VALUE and LAST_VALUE with the CTE. This doesn't cause a problem for FIRST_VALUE (naturally!) but definitely a bug.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
December 10, 2011 at 3:03 am
Cadavre (12/9/2011)
Sorry if it feels like I'm pestering you Gail, I just like to understand why. For me, what you're describing contradicts what I believed as the why, so I want to understand 🙂
I didn't spend much time investigating the why. The real code was more complex, so likely something got lost in the simplification.
I do have a QotD based on it that I might submit, maybe 2.
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 10, 2011 at 3:28 am
Paul's Time Travel :Whistling:
(see the attachment)
December 10, 2011 at 3:33 am
Dev (12/10/2011)
Paul's Time Travel :Whistling: (see the attachment)
Yes, I had an email today saying it would be republished on that date (no doubt you saw my post about that). SSC is weird.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
December 10, 2011 at 3:39 am
SQL Kiwi (12/10/2011)
Dev (12/10/2011)
Paul's Time Travel :Whistling: (see the attachment)Yes I had a email today saying it would be republished on that date (no doubt you saw my post about that). SSC is weird.
Yup... I saw your post and it triggered me to post it here so that everyone can enjoy it. Hope you didn’t mind it 😉
December 10, 2011 at 8:02 am
SQL Kiwi (12/10/2011)
Turns out the parser is sending 'range between unbounded and current' for both FIRST_VALUE and LAST_VALUE with the CTE. This doesn't cause a problem for FIRST_VALUE (naturally!) but definitely a bug.
Thanks for looking into this Paul, and for confirming it.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
December 10, 2011 at 1:00 pm
Go listen to this. Seriously. http://dotnetrocks.com/default.aspx?showNum=690
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 10, 2011 at 3:43 pm
GilaMonster (12/10/2011)
Go listen to this. Seriously. http://dotnetrocks.com/default.aspx?showNum=690
Seriously? You want me to spend 45 minutes listening to someone talk about Agile development with .NET?
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 15 posts - 32,476 through 32,490 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply