Viewing 15 posts - 41,206 through 41,220 (of 49,571 total)
The only time an adhoc plan will be reused is if the sql matches exactly to the one that create the plan. Exactly meaning down to the white space and...
February 5, 2009 at 3:24 pm
Jack Corbett (2/5/2009)
I believe that if you reorganize or rebuild stats for that index are updated automatically.
Rebuild, yes. Reorganise, no.
February 5, 2009 at 1:59 pm
Steve Jones - Editor (2/5/2009)
The limits change at times in versions, but to date I haven't heard anyone talking about reaching the limits.
If anyone in the world has a 500...
February 5, 2009 at 1:54 pm
Post the deadlock graph?
Two selects should not be able to deadlock unless there are strange locking hints used.
February 5, 2009 at 1:52 pm
trackingraj (2/5/2009)
1. I found in the book, the CD of this training kit is available. Where can I download this CD freely ? - please mail me trackingraj@gmail.
No portion of...
February 5, 2009 at 1:50 pm
trackingraj (2/5/2009)
Based on your message, I came to know that the ceritication will expire soon ?
It'll never expire.
MS thought about the expiry, but didn't implement it. Your cert will be...
February 5, 2009 at 1:48 pm
nilmov (2/5/2009)
Changing the recovery model to simple and bring to full will help
But will break the log chain with all attendant risks and concerns.
and its better than truncate_only as...
February 5, 2009 at 1:37 pm
rudy komacsar (2/5/2009)
It workd on SQL 2000 ...
Thanks for the test.
February 5, 2009 at 1:36 pm
It did wait until the lock was released.
A shared lock is released as soon as the select has finished (in the default isolation level). You either need to do a...
February 5, 2009 at 9:10 am
psangeetha (2/5/2009)
I'm hoping the lock to the child table in exclusive mode will solve this problem, for testing.
No, it won't. If there's a foreign key in place and...
February 5, 2009 at 8:49 am
Christopher Stobbs (2/5/2009)
Now I've drawn up some tests to read some execution plans for unions.And I don't really see anything that looks very costly?
See a hash aggregate or a sort?
Union...
February 5, 2009 at 8:41 am
Ahmad Osama (2/5/2009)
GilaMonster (2/4/2009)
Why do you want to truncate and/or shrink your transaction log?
I have a job to rebuild indexes..this increases the transaction log size....so i want to truncate...
February 5, 2009 at 8:30 am
meichner (2/4/2009)
February 4, 2009 at 12:05 pm
Ahmad Osama (2/4/2009)
in those cases I hv used dbcc shrinklog to truncate log.....
Shrink file will never truncate the log. It shrinks the file. Truncate refers to discarding old log records...
February 4, 2009 at 11:51 am
Why do you want to truncate and/or shrink your transaction log?
February 4, 2009 at 11:48 am
Viewing 15 posts - 41,206 through 41,220 (of 49,571 total)