Viewing 15 posts - 43,756 through 43,770 (of 49,571 total)
ananda.murugesan (10/15/2008)
Any one give me tips, how to recovery data?
To put it very bluntly, you don't.
Why don't you have backups?
October 15, 2008 at 2:29 pm
Leo (10/15/2008)
Hi Gila,Have you got a code for Index Rebuild with full scan? I am using SQL 2000.
Thanks.
No such command. Full scan applies to statistics updates, not index rebuilds.
See DBCC...
October 15, 2008 at 2:27 pm
Leo (10/15/2008)
1. Does Simple Recovery Model not backup the log? If do so, I will ignore the shrink.
No. In simple log records are discarded at regular intervals. It's not possible...
October 15, 2008 at 2:22 pm
Leo (10/15/2008)
So you mean, Just 'Index Rebuild' then Backup the DB? No Defrag Or Shrink?
Rebuild does everything that defrag does and more.
Shrink, as Lynn and Jack said, is not a...
October 15, 2008 at 2:18 pm
Could you perhaps explain a bit more what you're trying to do and why?
TempDB can't be restored or attached. For that matter, it can't be backed up or detached. It's...
October 15, 2008 at 2:18 pm
One other thought....
If you query sys.dm_os_wait_stats, what are the waits with the highest wait times (say the top 20)?
October 15, 2008 at 2:15 pm
Alan (10/15/2008)
Rebuild/Reorg IndexesUpdate Stats - I know this is somewhat redundant with auto stats on but I still do it
Not just that, but the rebuild of an index updates stats...
October 15, 2008 at 2:12 pm
If they want to change the owner of the system databases, ask them for the justification for that request.
October 15, 2008 at 2:07 pm
Andy Leffler (10/15/2008)
What's the best way to go about this?
The code I gave you will show which processes are involved in the blocking. Use the...
October 15, 2008 at 2:03 pm
You can rename sa safely. The database's owner references the login's SID, not the login's name . Even if you change the name of sa, the SID remains the same.
If...
October 15, 2008 at 10:01 am
Two questions first
Would you be allowed to make changes to the SQL code?
Would you be allowed to make changes to the indexing?
If not, would you be able to recommend/suggest to...
October 15, 2008 at 9:59 am
Grant Fritchey (10/15/2008)
OK. That's twice. It should stop now.
:hehe: 😀 Great minds think alike?
I'll go do something else for a while...
October 15, 2008 at 8:57 am
Grant Fritchey (10/15/2008)
Oops. There I am typing up the response and looking for your URL and there you are posting it. Ah well. Reinforces the point.
😀
October 15, 2008 at 8:52 am
If you're having problems with trace, you can try querying the procedure cache. It should pick up the most expensive queries.
select total_worker_time/execution_count/1000 as AverageCPUTime, total_elapsed_time/execution_count/1000 as AvgDuration, st.text
from...
October 15, 2008 at 8:48 am
Please don't cross post. It just wastes people's time and fragments replies.
Replies to the following thread please
http://www.sqlservercentral.com/Forums/Topic586071-360-1.aspx
October 15, 2008 at 8:38 am
Viewing 15 posts - 43,756 through 43,770 (of 49,571 total)