Hi I am facing the same problem with excel file. Somehow I am getting error message whenever he try to map the 2nd last row.I ahve checked the excel...
One thing Can i run this query during peak time hours? Mansoor
Yes I run the query mentioned by VBKENYA. I feel the difference just after the completion of query but after hour or two the system response again...
I did two things through enterprise manager,maintenance plan wizard.First I perform integrity check with include indexes and when it was finished the...
Is this possible that I can update statistics "with sample 100 percent" on database level because right now I have to update statistic manually on...
I run this trace with the option of only 500MB File, but the trace was run during peak hour time and it took almost one hour for 500MB file. Also...
I run one trace file yesterday and at the end it gives me analysis that if i will follow the recommendations than I will get the 28% performance...
Is full-text language search similar to Microsoft Search or they are different things?. Regarding Update Statistics, I have upgraded the server...
I didn't do auto update manually. The auto update statistics check box is checked in database properties. Now what do u suggest, should i run the...
What I did for upgrade, I first detach my database than reinstall the SQL Server 2000 with default collation name of arabic. than i reattach my...
I have both RAID 5 and 1 Configured on Server MAchine. Also AWE is enabled and I have fixed 6GB for the sql server. The database response to the...
Dears I am facing very serious problem regarding SQL Server 2000 DAtabase... Couple of weeks before I have upgrade my database with new default...
Separate names with a comma.