0
votes
1answer
369 views

Creating indexes on tables filled from transactional replication - SQL 2005

I've got two SQL 2005 servers, one OLTP [let's call it SQLA] and one used for reporting [SQLB] to reduce load on SQLA when people run crazy queries. Our main database is replicated from SQLA to SQLB ...