SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Slicing and Dicing


Slicing and Dicing

Author
Message
matt stockham
matt stockham
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2506 Visits: 3178
jpowers (8/12/2009)
Personally, I would prefer to pay only for the channels I watch. I see no reason why they can't allow us to pay just for our preferred entertainment.


I'm sure everyone would like to reduce their costs by excluding the channels they never watch. The flip side is that some of those channels that you do want to watch might not exist any more, or they might charge more to receive than you have saved by not bundling. It all depends on whether you like the mainstream channels or something a little more obscure.
Lynn Pettis
Lynn Pettis
SSC Guru
SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)

Group: General Forum Members
Points: 90576 Visits: 38945
matt stockham (8/13/2009)
jpowers (8/12/2009)
Personally, I would prefer to pay only for the channels I watch. I see no reason why they can't allow us to pay just for our preferred entertainment.


I'm sure everyone would like to reduce their costs by excluding the channels they never watch. The flip side is that some of those channels that you do want to watch might not exist any more, or they might charge more to receive than you have saved by not bundling. It all depends on whether you like the mainstream channels or something a little more obscure.


The other side of the coin is that it may actually be cheaper for the cable/satellite companies to get the extra channels many people may not watch than to not get them from the various content providers. Bundling may be more cost effective for them as well.

Cool
Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
jcrawf02
jcrawf02
SSCarpal Tunnel
SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)

Group: General Forum Members
Points: 4724 Visits: 19324
matt stockham (8/13/2009)
jpowers (8/12/2009)
Personally, I would prefer to pay only for the channels I watch. I see no reason why they can't allow us to pay just for our preferred entertainment.


I'm sure everyone would like to reduce their costs by excluding the channels they never watch. The flip side is that some of those channels that you do want to watch might not exist any more, or they might charge more to receive than you have saved by not bundling. It all depends on whether you like the mainstream channels or something a little more obscure.


But at least you'd be paying for value that you wanted, rather than fluff you did not, to the possible exclusion of what you do want.

---------------------------------------------------------
How best to post your question
How to post performance problems
Tally Table:What it is and how it replaces a loop

"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."
sjsubscribe
sjsubscribe
Mr or Mrs. 500
Mr or Mrs. 500 (541 reputation)Mr or Mrs. 500 (541 reputation)Mr or Mrs. 500 (541 reputation)Mr or Mrs. 500 (541 reputation)Mr or Mrs. 500 (541 reputation)Mr or Mrs. 500 (541 reputation)Mr or Mrs. 500 (541 reputation)Mr or Mrs. 500 (541 reputation)

Group: General Forum Members
Points: 541 Visits: 595
matt stockham (8/13/2009)
jpowers (8/12/2009)
Personally, I would prefer to pay only for the channels I watch. I see no reason why they can't allow us to pay just for our preferred entertainment.


I'm sure everyone would like to reduce their costs by excluding the channels they never watch. The flip side is that some of those channels that you do want to watch might not exist any more, or they might charge more to receive than you have saved by not bundling. It all depends on whether you like the mainstream channels or something a little more obscure.


You mean more than what I'm paying now for a bundle? In any case, let the market and tastes decide the fate of those individual channels. Right now, we get only those bundles where the cable companies have negotiated favorably. It's not based on demand. Last year, in my area, we had trouble getting pay-per-view NFL because of contract disputes between NFL and cable company though the demand was extremely high.
Steve Jones
Steve Jones
SSC Guru
SSC Guru (140K reputation)SSC Guru (140K reputation)SSC Guru (140K reputation)SSC Guru (140K reputation)SSC Guru (140K reputation)SSC Guru (140K reputation)SSC Guru (140K reputation)SSC Guru (140K reputation)

Group: Administrators
Points: 140301 Visits: 19415
And there's the rub, we don't get to negotiate things, or get more choice. We also get what is negotiated, which definitely isn't always a good thing for consumers.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Ronald Bruintjes
Ronald Bruintjes
SSC Journeyman
SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)

Group: General Forum Members
Points: 97 Visits: 28
jcrawf02 (8/13/2009)
matt stockham (8/13/2009)
jpowers (8/12/2009)
Personally, I would prefer to pay only for the channels I watch. I see no reason why they can't allow us to pay just for our preferred entertainment.


I'm sure everyone would like to reduce their costs by excluding the channels they never watch. The flip side is that some of those channels that you do want to watch might not exist any more, or they might charge more to receive than you have saved by not bundling. It all depends on whether you like the mainstream channels or something a little more obscure.


But at least you'd be paying for value that you wanted, rather than fluff you did not, to the possible exclusion of what you do want.


Not necessarily...

Have you noticed the new trend, where on one and the same channel there is bundling? Take for example SyFy channel (named that way because English was unbundled in the educational package? Not sure...), which now not only hosts various gradations of Science Fiction and Fantasy series and movies, but also features Wrestling. How can I unbundle that...? ;-)
GSquared
GSquared
SSC Guru
SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)

Group: General Forum Members
Points: 54945 Visits: 9730
Ronald Bruintjes (8/17/2009)
jcrawf02 (8/13/2009)
matt stockham (8/13/2009)
jpowers (8/12/2009)
Personally, I would prefer to pay only for the channels I watch. I see no reason why they can't allow us to pay just for our preferred entertainment.


I'm sure everyone would like to reduce their costs by excluding the channels they never watch. The flip side is that some of those channels that you do want to watch might not exist any more, or they might charge more to receive than you have saved by not bundling. It all depends on whether you like the mainstream channels or something a little more obscure.


But at least you'd be paying for value that you wanted, rather than fluff you did not, to the possible exclusion of what you do want.


Not necessarily...

Have you noticed the new trend, where on one and the same channel there is bundling? Take for example SyFy channel (named that way because English was unbundled in the educational package? Not sure...), which now not only hosts various gradations of Science Fiction and Fantasy series and movies, but also features Wrestling. How can I unbundle that...? ;-)


I feel old when I type that I can remember when MTV was a medium for watching music videos....

I consol myself on that point when I realize that I'm not old enough to remember when TV news was about information, instead of about marketing and political indoctrination.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
jcrawf02
jcrawf02
SSCarpal Tunnel
SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)

Group: General Forum Members
Points: 4724 Visits: 19324
Ronald Bruintjes (8/17/2009)Have you noticed the new trend, where on one and the same channel there is bundling? Take for example SyFy channel (named that way because English was unbundled in the educational package? Not sure...), which now not only hosts various gradations of Science Fiction and Fantasy series and movies, but also features Wrestling. How can I unbundle that...? ;-)


Funny, but I happen to agree with their categorization of Wrestling into Fantasy.....;-)

---------------------------------------------------------
How best to post your question
How to post performance problems
Tally Table:What it is and how it replaces a loop

"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."
Wellington Aquino
Wellington Aquino
SSC-Enthusiastic
SSC-Enthusiastic (156 reputation)SSC-Enthusiastic (156 reputation)SSC-Enthusiastic (156 reputation)SSC-Enthusiastic (156 reputation)SSC-Enthusiastic (156 reputation)SSC-Enthusiastic (156 reputation)SSC-Enthusiastic (156 reputation)SSC-Enthusiastic (156 reputation)

Group: General Forum Members
Points: 156 Visits: 243
I believe most of the opinions against bundling, and the 'free-choice' perspective might have their sustained reasons. However, bundling allows a small member of a business model to take a proportional part of it. In the case of Golf Channel, it couldn't be possible for them to compete with ESPN nor FOX Sport, in example. Nevertheless, they have the part of the "pie" that they are entitled to; and of course, its TV technicians, IT technicians, journalists, and reporters, grow up everyday as professionals, and feed their families thanks to that.
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (205K reputation)SSC Guru (205K reputation)SSC Guru (205K reputation)SSC Guru (205K reputation)SSC Guru (205K reputation)SSC Guru (205K reputation)SSC Guru (205K reputation)SSC Guru (205K reputation)

Group: General Forum Members
Points: 205017 Visits: 41952
Heh... it doesn't matter if anything is bundled or not... you're still going to pay too much. :-D

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search