Ok but on an user Table, it produce the same behaviour : ALTER INDEX ALL ON Tasks REBUILD WITH (SORT_IN_TEMPDB = ON); SELECT INDEX_ID,...
I Try this : ALTER INDEX ALL ON MSmerge_contents REBUILD WITH (SORT_IN_TEMPDB = ON); SELECT INDEX_ID, index_type_desc, AVG_FRAGMENTATION_IN_PERCENT...
Rebuilding,<br /><br /><font color="blue">DECLARE @DBname VARCHAR (64)<br />DECLARE @MaxFrag DECIMAL<br />DECLARE @Fragmented VARCHAR (64)<br /><br...
I rebuild all Index with index_id >= 1 on a user table but they are still fragmented after (> or = 1) Regards
Hi all, Why when I Rebuild all fragmented indexes (ALTER INDEX on > 30%) from a table, many indexes remain fragmented and cannot be defragmented ?...
Great , thanks a lot four your supports Bests Regards
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...
Great, I drop the plan and recreat-it and it's working ... Thanks a lot four your supports Regards
The Maintenance Plan is : - Check Database integrity / Reorganize index / Update Statistics. I use only 1 DataBase for the test, moreover if I only...
The end of the trace shows that : EXECUTE msdb..sp_maintplan_close_logentry '797A2FFE-7F8B-46C3-AB12-B9E200DDBF00',NULL,1 --> So the plan succed...
The patch is applied. How to see the conversion error and how to check the changes ? Thanks for your supports Regards
The owner of the Job is 'sa' (sysadmin) which is mapped to the DB with user = dbo and default schema = dbo. Regards
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...
Thanks for your support, So , When I Rebuild All Index and then I execute an Insert Query, this query should not update/creates statistics (already...
Thanks for your support
Thanks, Our plan is : Check Integrity/BackUp Full/Reindex/Update Stat/Maintenance CleanUp (clean backUp > 2 week) This plan does not include :...
Yes, I perform a full Index Rebuild, update Stat and then I execute a query (insert) and it take 2 min. to be completed, the trace show us that the...
1. The size of our DBs is from 200 MB to 1 GB Max. 2. Every Evening, we make a Full BackUp (Not the system dbs) 3. The tempDB settings :...
Yes, from 30 --> 60 sec, but somes query (just 1 insert on a 1000 rows table for exemple) takes 2 minutes to be completed ...
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...
Separate names with a comma.
