richardgregory06 (4/23/2014)
I"m still a bit confused which is typically the "Best Practice" to where I should put the criteria
It depends!
Check which method yields the best performance.
p.s.
Which is better
asking SQL Server to select a thousand rows from one million and pass a thousand rows to the Report Server
or
asking SQL Server to pass a million rows to the Report Server and asking the Report Server to filter for a thousand rows.
Far away is close at hand in the images of elsewhere.
Anon.