Browse by Tags

• backups
• best practice
• busy
• cache
• cpu
• create
• creation
• databases
• dbcc shrinkfile
• huge
• memory
• monitoring
• online
• performance
• sql server
• tsql
• users

SQL Server - Have you observed DBCC SHRINKFILE operation performance, on huge databases?
25 April 08 01:30 AM | SQL Master | 2 Comments   

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 Read More...

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

SQL Server 2005 Enterprise Edition - make data available while creating indexes on large tables!
25 January 08 02:41 AM | SQL Master | 3 Comments   

Though it is not a best practice to perform a CREATE INDEX on large tables during the online hours where you have number of users accessing the metadata of SQL Server database. Within SQL Server 2005 Enterprise Edition you can perform ONLINE indexes operation, Read More...

Filed under: performance, sql server, cache, indexes, tsql, users, best practice, backups, monitoring, operating system, creation, create, online, busy