Gone With the Wind
-
Gone With the WindIt's gone, but only for awhile. If you're a heavy user of Reporting Services in SQL Server 2005, you might have noticed a small change in the drop downs. The "SELECT ALL" option was removed in SP1, supposedly because of a performance problem with the way the query was implemented behind the scenes. It was using an IN clause, which can cause issues with large numbers of values.
I get that and it's a nice idea, but apparently lots of people used that feature so it's being returned in SP2. It's good to see Microsoft paying attention to feedback and responding when necessary.
However I'm a little surprised that the people that have written such a wonderful optimizer couldn't come up with an efficient way to handle the select all query. I get that it's not as simple as a "SELECT *" with no WHERE clause, but removing a feature seems drastic.
Especially in a Service Pack.
This gets back to my complaint, and that of many other people, about functionality changing in service packs. Not bugs being fixed, but core functionality being added (or removed) from the product. Service Packs should only address issues with the product. Everything else should be moved to an "add-in" product.
Like Reporting Services used to be.
Steve Jones
-
Total agreement Steve...
I say if the product works pretty well, then wait for the next release before adding or removing features. Many companies make this mistake when they should just be fixing bugs and handling security issues.
-
I just finished reading an article on this yesterday:
https://blogs.msdn.com/bwelcker/archive/2006/08/14/700189.aspx
We lost it with SP1, but currently there is a patch and it should be back with the next SP.
Gone With the WindViewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply