Viewing 15 posts - 76 through 90 (of 303 total)
Thank you..
Finally, I deleted the statistics from production sql 2000 in Mydb2 and restored in sql 2005.Now I did not see any warnings/errors.
I have one more question in the...
February 19, 2009 at 11:48 pm
drop the auto created stats from the sql2000 prod database, otherwise each time you restore that db the corrupted object will still be there,
does this make sense
I think...
February 19, 2009 at 5:09 pm
Thanks Gail,
As Noil said First of all you should drop that stat (in case it was "upgraded" from 2000)
Then run an update of the stats with fullscan and also...
February 19, 2009 at 3:38 pm
thank you..
Warning: A column nullability inconsistency was detected in the metadata of index "_WA_Sys_key2354" (index_id = 3) on object ID 2235454631 in database "MyDB". The index may be corrupt. Run...
February 19, 2009 at 1:19 pm
thank you.
Yes, someone could probably go and create a statistic manually with exactly the same form, but is that really likely?
Iam not sure that somebody manually created these...
February 19, 2009 at 11:58 am
thank you.
To drop the statistics:
1.I have to go database Mydb and execute drop statistics statstics name right?
2.how do we know these statistics are automatically created?
and I came to...
February 19, 2009 at 1:58 am
hi Gail,
Drop all the statistics referenced in the error messages. SQL will recreate them if it needs.
Maybe run a checkcatalog on the sql 2000 database?
I did not understand what...
February 19, 2009 at 1:27 am
After upgrading from Sql server 2000 to 2005 what are the DBCC commands do we need to run inorder to make sure all databases are in correct state.
Thank you
February 17, 2009 at 11:54 pm
Thank you
We have Raid 10 SAN storage drives.
Disk lay out as below:
D:datafiles
E:Secondary data files
F:log files
Z:Backup Drive
and the instance is clustered.
I did not understand why Iam getting high disk Queue...
February 17, 2009 at 11:39 pm
Could you please clarify me what to do to get rid of this error?
I searched google a lot but i did not find the solution. Is it really with the...
February 17, 2009 at 5:07 pm
Thank You..
We are not using Kerboros for webservice. We are using NTLM.Eventhough we using NTLM do we need to check for invalid SPNs in active directory?
Is this any serious issue?
February 17, 2009 at 2:14 pm
Could you please give me some info on this and at the same time we got errors in sharepoint servers also as below:
vent Type:Error
Event Source:Office Server Search
Event Category:Gatherer
Event ID:10036
Date:2/16/2009
Time:15:20:30...
February 17, 2009 at 1:33 pm
I tried to analyze the SQLIOsim output and I noticed the below:
DRIVE LEVEL: Read cache enabled = Yes, Write cache enabled = No</EXTENDED_DESCRIPTION[/b]
So, what will be the better approach...
February 13, 2009 at 12:06 pm
I attached the results of SQLIOsim in word pad. I would like to know how to analyze this..
Thanks
February 12, 2009 at 6:07 pm
Do We need run the DROP STATISTICS statisticsname on the production SQL server 2000?
February 12, 2009 at 11:33 am
Viewing 15 posts - 76 through 90 (of 303 total)