Welcome to the forums. I really doubt if its possible to undo the changes in your case as you said u dont have a back up of DB before the changes....
Try the following link. It may help....
Hi Guys, Please excuse me if my query is out of the scope of this section. I want to know what are the exams i need to pass out to get microsoft...
We had similar problems when we had upgraded to 2005 from 2000. We did not change the hardware configuration for this. The following actions helped...
It should not take this much time to retrieve the data. But here the problem is that your CPU usage is 100% very frequently. that means there is a...
Let me know whether the execution plan shows it is using non-clustered index scan or seek. Any delete operations are going on in large scale on this...
Im suggesting a better practice. Do not use cursors whatever may be the requirement. Cursors create overheads while execution and they are usually...
Separate names with a comma.
