Search Results

Thread by: Hollywood, Apr 24, 2007, 10 replies, in forum: SQL Server 2005 General DBA Questions

Hi all, Why when I Rebuild all fragmented indexes (ALTER INDEX on > 30%) from a table, many indexes remain fragmented and cannot be defragmented ?...

Thread by: Hollywood, Apr 24, 2007, 5 replies, in forum: SQL Server 2005 General DBA Questions

Hi all, Which Job(s) must be created to optimize the systems Database and keep them uptodate ? Our sql server heavy use Merge Replications ... Is...

Thread by: Hollywood, Apr 23, 2007, 13 replies, in forum: SQL Server 2005 General DBA Questions

Hi all, I get always an error when running a maintenance plan Job. All steps in the job are succesfull but the job reports always : Executed as...

Thread by: Hollywood, Apr 5, 2007, 11 replies, in forum: SQL Server 2005 Replication

Hi all, We often meet problems of Timeout during first requests SQL on large Tables when a publication is activated on the DB. It seems after...

Thread by: Hollywood, Apr 5, 2007, 8 replies, in forum: SQL Server 2005 General DBA Questions

Hi all, Our maintenance plan for our Server (SQL 2005) makes Reorganize of index every evening then Update Statistics; should make a complete...