| http://www.w3.org/ns/prov#value | - If performance is an issue, one of the many things to check is the fill factors, and be aware when you use SQL Server 2000 maintenance plans and accept the defaults, it sets all tables in the plan to a fill factor of 90%, but SQL 2005 defaults to 100%, so its often missed as an area to look at in SQL 2005. - It can make a big difference to performance on busy servers.
|