Viewing 15 posts - 136 through 150 (of 859 total)
Please do not cross post.
All replies to :
http://www.sqlservercentral.com/Forums/Topic711291-146-1.aspx
May 7, 2009 at 6:09 am
Best Practice:
1.)Identify indexes that are of fragmentation
2.)Defrag indexes with less fragmetation, thumb of rule 30%.
Wouldn't be a good idea to rebuild all the indexes since its taking longer time to...
May 6, 2009 at 7:14 pm
ashishnigam04r (5/6/2009)
the Error is" Create file encountrerd operating system error 5(access is denied" while attempting to open or create...
May 6, 2009 at 6:24 pm
You have two options there either the users are kicked off while restoring the tlogs or the secondary server has to wait till all the users are disconnected.
Since you are...
May 6, 2009 at 6:08 pm
There are very little options here. You need to break the mirroring session and reduce the log file size and re configure the DB AFAIK.
May 6, 2009 at 5:35 pm
Is there any timeout interval specified in your code?
Check out for any kind of blocking or deadlocking on your server?
May 6, 2009 at 4:06 pm
ang (5/6/2009)
I guess I will hold off unless I find a bug. Thank you for your responses.
Yes you should hold the CU's unless you face that specific problem. Usually...
May 6, 2009 at 4:05 pm
Krasavita (5/6/2009)
ResType:LockOwner Stype:'OR' Mode: S SPID:67 ECID:0 Ec:(0x28225578) Value:0x7e96b060 Cost:(0/0) I get this in SQL Logs what is this mean?
Its a lock on a resource by the SPID 67 and...
May 6, 2009 at 1:50 pm
PaulB (5/6/2009)
Krishna Potlakayala (5/6/2009)[DR is the basic building block of a any online business.
I agree but I would add that doesn't matter if the affected systems are supporting an online...
May 6, 2009 at 12:50 pm
DR is the basic building block of a any online business.Personally it makes me more confident having a solid DR plan.
I always tend to give this example to everyone that...
May 6, 2009 at 12:39 pm
SQL-KV (5/6/2009)
Ohh Yeah thanks... 🙂But i wish i would have seen some errors and fix them. So that i would have learnt new thing..
Definitely you should practice, even when you...
May 6, 2009 at 12:12 pm
AlexSQLForums (5/6/2009)
since it's a possible index corruption you should rebuild your indexes and schedule it at least once a week via maintenance plan.
Choosing index rebuild or not depends on the...
May 6, 2009 at 12:08 pm
Henry Treftz (5/6/2009)
Another option when you get a index error message is to just drop and re-create the index.
No, it depends on the level of corruption on the indexes....
May 6, 2009 at 12:01 pm
RevProd.master.sys.databases
What access have u got to this server?
May 4, 2009 at 3:38 pm
Jules Bonnot (5/4/2009)
May 4, 2009 at 1:59 pm
Viewing 15 posts - 136 through 150 (of 859 total)