Management Studio provides a neat GUI interface to define maintenance plans for your SQL databases. This tool is available under Management -> Maintenance Plans and provides many great Maintenance Plan Tasks that you can configure easily. There are many useful tasks such as “Check Database Integrity Task”, “Back Up Database Task”, “Rebuild Index Task”, etc.
Posts Tagged ‘DBCC’
November 17, 2011 by Francois · Leave a Comment
Filed under: Administration
Social Tagging: DBCC • fragmentation • Maintenance Plan • NOTRUNCATE • SHRINKDATABASE • SHRINKFILE • TRUNCATEONLY
Filed under: Administration
Social Tagging: DBCC • fragmentation • Maintenance Plan • NOTRUNCATE • SHRINKDATABASE • SHRINKFILE • TRUNCATEONLY
June 2, 2011 by Francois · Leave a Comment
Filed under: Administration
Social Tagging: DBCC • memory • server properties
Filed under: Administration
Social Tagging: DBCC • memory • server properties
The default value for SQL Server 2008 Maximum Server Memory setting is 2,147,483,647 MB (or 2.1 petabytes!). Therefore, by default, SQL Server will use all available memory for its own use:
RSS