7. February 2009 11:12
By
robault
In
SQL | TSQL
Image via Wikipedia
What a SQL re-indexing process should be doing:
1. Re-indexing indexes or tables over 30% fragmentation (BOL). Some estimates are 15-20% or more.
2. Reorganizing indexes or tables less than 30% fragmented (BOL). Some estimates are 2%-10%.
3. It ap...
[More]
5. February 2009 11:09
By
robault
In
Hardware | IT/IS | SQL | TSQL
Image via Wikipedia
You probably don’t have a DBA on site but you need some DB maintenance.
A DBA is a resource developers hope would be there when their product ships, but most companies don’t realize the importance of having someone actively managing their SQL servers. SQL is good e...
[More]