I have a slow query. It is indexed and I was wondering if there were any issues with using 'dbcc dbreindex' on each of the 12 replicas, to maybe make it run more efficiently And is this something I could/should do nightly
recreate index on replica
Hot Topic
- Can't Create New Database on Device via ActiveSync
- Asp.Net not finding the SQLServer for setting up Security problem
- Must you use 3rd party certs for mobile ssl replication?
- FailParentOnFailure not working?
- problems with codepage
- Problem starting Maintenance Plans
- Remote tables
- Cant See Network Server
- AggregationFunction = None
- Transactions in NS API (Found a way to do it)
SQL Server
- Programatically Evaluating SSIS Expression
- which one is better to use? (@@rowcount or using Exists)
- NULL values in Cube for measures
- Native XML in SQL Express 2005 same as SQL 2005 standard, workgroup and enterprise?
- Configuration of RSreporthost
- Trouble with XML Bulkloading from a stream
- using rank
- Out of Memory
- New Login with Trusted Connection
- Viewing a "View"...
recreate index on replica
RyanJ
Why would you want to reindex the tables, what is this going to gain you Are these replication metadata tables, or user tables If these are user tables, you should look at the execution plan of your slow-running query via profiler. In the future, if this does not involve replication, you may get more response in the Transact-SQL forum - http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=85&SiteID=1.
If this indeed is a query on a replication metadata table, then post here the query and the execution plan.