In RDL, we can do filter and sorting in Query: "Select * from tables where field_a > 100 order by field_b", or in "Filters" and "Sorting":
<FilterExpression> = Fields!Field_a.Value </FilterExpression>
<Operator> GreaterThan </Operator>
<FilterValue> = 100 </FilterValue>
<SortExpression> = Fields!field_b.Value <SortExpression>
I wonder which way is more efficient in terms of application performance (such as response time...).
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…