Perry;

Ok. Thanks for the information. I will do as such (Rewrite Packages).

Thanks a million

Thanks Perry;

My Upgrade needs to be completed as fast as possible. So you advise I should leave them in Legacy mode then eventually after a successful Upgrade we can Re-write...

I am more concerned with DTS Packages from SQL 2000, Is it possible to let all of them run on Legacy Mode or it is advisable to upgrade them to...

Michael, we used to fight with Develpoers on why the report has failed. Now you can see on the Subreport "ReportErrors". Now we can see who went on to give...

This article loooks good

Gail;

I am not sure but another issue on FILL FACTOR. If you do not spacify PAD_INDEX then I discovered that the mechanism will not create a fill factor by the...

TheSQLGuru

I can see that. Sorry about that

Thank you Gail for that because I read somewhere where TheSQLGuru was "asking" for more Clustered Indexes on a single table

TheSQLGuru

I am not quite sure about many Clustered Indexes here. Since the concept tells us that they are part of the table and determine the Ordering of data,then with...

karl;

Dont avoid dividing by Zero. SQL has a very good facility to overcome that. For instance, run these 2 queries and tell me the results:

(1)

DECLARE @a Money,

gavinparnaby :

Sorry, I will check your sub query and I will give you feedback tomorrow. Please bear with us.

gavinparnaby :

If I undestend you correclty you are saying you are getting there is a resultset of duplicate indexes of differnt tables. I need to be corrected here. Indices are...

Kristof

sure, checked. Kristof is right.

gavinparnaby

Its very normal to get multi rows for one index. For instance if you run your

sys.dm_db_index_physical_stats(db_id(), OBJECT_ID('<tableName>') ,NULL,NULL,'DETAILED'). Yuo are likely to get so many rows of one...