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 Integration Services and Clustering - confguration gotcha to ensure SSIS works with failover of cluster!
17 March 08 01:06 PM | ssqa.net | with no comments

A newbie or FAQ within Forums and Newsgroups that having multiple instances and how best to set the resources on the server such as memory, CPU etc. Read more from here.

Filed under: sql server, best practices, configuration, benefits, management studio, multiple, memory, instances, cpu