Difference between report builder and report designer

Report Builder is a web-based tool to create reports. Report Builder is assessable through the Report Manager so the reports developed are bydefault stored in the Server but reports developed using Report designer of BIDS available in MS Visual Studio can be stored as RDL Files in the local or can be stored in the server. There is no compulsion as such. Report Builder is basically used by the end-users for developing some basic reports with little features as compared to the large functionality of Report Designer in BIDS which is mainly used by developers. A report builder looks more … Click here to continue…..

Types of SSRS Reports

Parameterized reports: When the output of a report is not static but instead depends on the input parameters supplied to the reports at run time, the report is known as a Parameterized report.Drillthrough reports, linked reports, subreport and all other report types are a kind of Parameterized reports. Linked Report: A linked report is a report server item that is derived from an existing report and retains the original report’s definition. A linked report always inherits report layout and data source properties of the original report. All other properties and settings can be different from those of the original report, … Click here to continue…..

Tips to improve performance of Database Operations

1) Return Multiple Resultsets The database code if has request paths that go to the database more than once then, these round-trips decreases the number of requests per second your application can serve. Solution: Return multiple resultsets in a single database request, so that you can cut the total time spent communicating with the database. You’ll be making your system more scalable, too, as you’ll cut down on the work the database server is doing managing requests. 2) Connection Pooling and Object Pooling Connection pooling is a useful way to reuse connections for multiple requests, rather than paying the overhead … Click here to continue…..

Major Points when Creating Indexes for a database

Best practices to follow when creating Indexes for a database. Examine the WHERE clause and JOIN criteria columns : SQL server Query optimizers looks for indexes on the columns specified in the WHERE clause and the JOIN criteria and if the indexes are available on these columns then optimizer considers Indexes when creating execution plan. Use Narrow Indexes : index on a column with narrow data type will improve performance by reducing storage space, reducing required IO and more effective caching. Prefer Column with high selectivity : Index on a column with a very low range of unique value will not yield any benefit in … Click here to continue…..

How to increase SQL Server performance

These are major problem that badly affects SQL Server performance. If you already know this problem area then you can design database and queries with better understanding. Poor Indexing: Without proper indexing SQL Server needs to retrieve and process much more data when executing. That means more use of disk,memory and CPU, and also increased execution time. That can lead to bloacking and deadlocks. Inaccurate Statistics: Accurate data distribution statistics are important for SQL Server so that it can design optimized execution plan accordingly. Poor Query Design: SQL queries should be written to make best use of indexes.Poorly designed queries can … Click here to continue…..