Blog Archives

Using Replication and Indexed Views to create a Reporting Server: Part 2

In my previous post, we looked at an overview of the two technologies we are combining to create a SQL Server reporting server: Indexed Views and Replication. As we saw, replication allows us to move our data from one server

Tagged with: , , ,
Posted in reporting, SQLserver, Uncategorized

Using Replication and Indexed Views to create a Reporting Server: Part 1

Reports that require heavy aggregation and run often can become taxing on our database, and perform poorly. Who wants that? Requiring our system to aggregate the data each time it is requested costs us time, and as any DBA knows,

Tagged with: , , ,
Posted in reporting, SQLserver
about.me