New Blog Post: RESTful Reporting
SELECT TOP 0 better than SELECT WHERE 'C'<>'C'
we know that the report builder before executing the report executes a select * from table where 'c' <> 'c', it would be interesting to change this concept, and to use a select top 0, because this has a much greater performance. the command and run in a view
in views that contain many unions the use of 'c' <> 'c' and extremely detrimental to the performance of the report
I changed the sources of the report builder by adding the TOP 0 and removing where 'c' <> 'c', but it would be nice if this were native in future versions, see in the comparative images