Useful SQL Server Index Fragmentation Query

Recently I had to brush up my skills on index fragmentation and as a result pulled this query together from a number of useful resources on the net. Just replace ‘DATABASE_NAME’ and run it against the specified database to receive a list of indexes that need attention. Internal Fragmentation is represented by the ‘avg_page_space_used_in_percent’ column… Continue reading Useful SQL Server Index Fragmentation Query

SQL 2008 R2 – The report server has encountered a configuration error. (rsServerConfigurationError)

After installing SQL server 2008 or SQL server 2008 R2 and using reporting services for the first time you may encounter this error: The report server has encountered a configuration error. (rsServerConfigurationError) Exactly as the error message says – you have not configured reporting services correctly. In my case it was because I had not… Continue reading SQL 2008 R2 – The report server has encountered a configuration error. (rsServerConfigurationError)

Rebuild MS SQL full text catalogs for commerce server 2007 search

If you are getting unexpected search results from you commerce server web application it could be caused by your SQL Server full text catalog indexs not been rebuilt. We experienced this issue while using the CS2007  agent APIs to created/modify virtual catalogs. The last step in the process triggers the rebuild of all the indexes using this SQL: … Continue reading Rebuild MS SQL full text catalogs for commerce server 2007 search