Browse by Tags

SQL Server - Have you observed DBCC SHRINKFILE operation performance, on huge databases?
08 May 08 09:35 AM | ssqa.net | 2 comment(s)

In general it is not a best practice to perform SHRINK database operation on a production server, atleast regularly! Sometimes it may be compulsory to keep them sized in order to ensure the disk storage is not compromised for any sudden changes to databases...

Filed under: sql server, indexes, memory, cpu, cache, huge, dbcc shrinkfile, monitoring, databases, operating system

SQL Server Reporting Services - avoid restarting IIS when security groups are added
14 April 08 10:07 AM | ssqa.net | with no comments

You may be aware that using normal method of http://servername/reports will give access to the users and if you grant reporting service permissions using the folder properties security (or report manager) to the Windows groups you might need to restart...

Filed under: sql server, report builder, reporting services, registry, cache, iis