Viewing 15 posts - 3,811 through 3,825 (of 7,187 total)
According to Books Online, with ALTER INDEX...REORGANIZE, "long-term blocking table locks are not held and queries or updates to the underlying table can continue during the ALTER INDEX REORGANIZE transaction"....
September 30, 2013 at 7:17 am
More than 1 what? According to the e-mail, what was the blocking query, and what was the blocked query?
John
September 30, 2013 at 7:03 am
Ivan Mohapatra (9/30/2013)
September 30, 2013 at 6:59 am
Yes, but how do you know it's the ALTER INDEX...REORGANIZE statement that's doing the blocking? The code you posted does more than that.
How long does the blocking have to...
September 30, 2013 at 6:57 am
What is a blocking email and under what circumstances do you get one? Have you managed to ascertain which particular statement is causing the blocking?
John
September 30, 2013 at 6:41 am
I don't know why that would hold a lock for a long period of time. Have you tried to use sys.dm_os_waiting_tasks to see which session is doing the blocking?
John
September 30, 2013 at 5:37 am
Rebuilding indexes will take locks; reorganising won't. Please will you post your code?
John
September 30, 2013 at 5:13 am
Chinna
You need to REVERSE the string and then look for the first space after the "@".
John
September 30, 2013 at 1:22 am
Sounds as if your database is in single user mode.
SELECT user_access_desc
FROM master.sys.databases
WHERE name = '****'
John
September 30, 2013 at 1:16 am
Bhuvnesh (9/27/2013)
i dont think only SP definiton will provide much help here . Exec plan will be required.
Do you think so? The warning messages occur at run time,...
September 27, 2013 at 8:31 am
OK, so you have a staging database and a live database, right? And one of those procs runs to "tidy up" the staging database before the other one runs...
September 27, 2013 at 8:23 am
OK, as has previously been requested, please will you post the definition of the stored procedure you mentioned?
John
September 27, 2013 at 4:40 am
shyamalarakesh (9/27/2013)
HI !As per my knowledge we cannot add .mdf files to tempdb database.just we can take only log backup's to reduce the size of databse
Unfortunately, your knowledge...
September 27, 2013 at 4:22 am
Sounds like you have a unique index with IGNORE_DUP_KEY set to ON. You get this warning when, and only when, you attempt to insert something that would violate the...
September 27, 2013 at 4:15 am
brett.y (9/27/2013)
in fact the ONLY one I understand
It's one of four very similar solutions that have been posted. The only ways they differ are as follows:
(1) Some use common...
September 27, 2013 at 1:18 am
Viewing 15 posts - 3,811 through 3,825 (of 7,187 total)