SQL Server 2012 Reporting Services Optimization Tips Try to restrict the report queries result set by using the WHERE clause and by returning only the particular columns from the table. This can results in good performance benefits, because SQL Server will return to client only particular rows and columns, not all rows and columns from the table(s). This can reduce…