SQL Server 2005 Database Maintenance Topics Useful For Confluence Administration

SQL
- How to tell if edition of SQL Server 2005 is 32-bit or 64-bit - http://blogs.msdn.com/b/sanchan/archive/2006/04/28/586167.aspx
  - Note: x86 is 32 bit
- 32-bit vs. the 64-bit SQL server performance surge - http://searchsqlserver.techtarget.com/tip/32-bit-vs-the-64-bit-SQL-Server-performance-surge
  - company trending toward offering only 64-bit editions
  - Note - you must register to read the rest of the article
- When to use AWE to allocate memory for SQL 2005 - http://dbaspot.com/forums/sqlserver-server/383333-when-would-one-use-awe-allocate-memory-sql-2005-a.html
  - If SQL server is 32 bit version, use AWE to let SQL server use more than 3GB of ram
- Why is SQL Server 2005 activity monitor timing out
  - Timeout in activity monitor - http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/c5f851e6-80d9-428e-a6c7-1536029d9637
  - google query: sql server 2005 activity monitor timeout
  - Google query: sql server 2005 "cannot display activity data"
- Troubleshooting SQL Server Management Studio with SQL Profiler and Debugging Tools
  - Part 1 - http://blogs.msdn.com/b/grahamk/archive/2009/10/20/troubleshooting-sql-server-management-studio-with-sql-profiler-and-debugging-tools-part-1.aspx
  - Part 2 - http://blogs.msdn.com/b/grahamk/archive/2009/10/20/troubleshooting-sql-server-management-studio-with-sql-profiler-and-debugging-tools-part-2.aspx
- SQL Server Performance
  - Performance issues for data warehouse and reporting applications - http://technet.microsoft.com/en-us/library/cc917690.aspx
  - Detecting table fragmentation - http://www.sql-server-performance.com/articles/per/detect_fragmentation_sql2000_sql2005_p1.aspx
    - If the table row(s) are modified or deleted frequently then it is better to run intermittent UPDATE STATISTICS on the table, which will help it avoid any slow performance from the execution plan.
  - Script to find index fragmentation - http://blog.sqlauthority.com/2008/03/27/sql-server-2005-find-index-fragmentation-details-slow-index-performance/#comment-88354
  - Google query: sql server 2005 index total fragmentation
- Indexing
  - Difference between index rebuild and index reorganize - http://blog.sqlauthority.com/2007/12/22/sql-server-difference-between-index-rebuild-and-index-reorganize-explained-with-t-sql-script/
  - Performing index operations online - http://msdn.microsoft.com/en-us/library/ms177442.aspx
  - Create index syntax - http://msdn.microsoft.com/en-us/library/ms188783(v=SQL.90).aspx
    - http://msdn.microsoft.com/en-us/library/ms188783.aspx
  - Fixing index fragmentation in SQL Server 2005 and SQL Server 2008 - http://www.mssqltips.com/tip.asp?tip=1791
    - Differences between reoganize and rebuild
    - rebuilding online
    - create index vs. alter index
    - script reorganizes and rebuilds the indexes if the fragmentation level is higher than the given threshold. You can define the threshold for reorganizing as well as for rebuilding and the script will work accordingly.
    - Has links to:
      - Index Fragmentation Report in SQL Server 2005 and 2008
      - SQL Server script to rebuild all indexes for all tables and all databases
- Partitioning and filegroups
  - Creating table partitions - http://blogs.techrepublic.com.com/datacenter/?p=139
    - Explanation: breaking one table or index up into smaller tables or indexes that act as one table or index. This can greatly increase performance because you are querying several smaller tables rather than one much larger one. The advantages increase when the server has multiple processors, which allow the partitions to be queried in parallel in the same query, and when the partitions are spread across multiple file groups.
    - Example: how to partition a table that stores archived data
      - Step one is to define the partition function that you will use to map out the partitions in the table.
      - In the Partition Function defined - three partitions, one for each product type in the SalesHistoryArchive
  - Moving an index to a different filegroup - http://msdn.microsoft.com/en-us/library/ms175905(SQL.90).aspx
    - Note that moving a clustered index will move the table to the new filegroup.
  - Partitioning tables and indexes - http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx
  - Question about index fragmentation in filegroup partitions - why does index fragmentation vary between paritions - http://www.eggheadcafe.com/software/aspnet/35790974/theoretical-question-about-index-fragmentation-in-filegroup-partitions.aspx
  - Google queries:
    - sql server 2005 filegroup free space
    - sql server 2005 move index to new filegroup
    - sql server 2005 rebuild index on different filegroup
    - sql server 2005 partitioning filegroups