Viewing 15 posts - 3,811 through 3,825 (of 7,185 total)
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
Who is Bueller?
Why don't you put the file in its own folder, then you don't need to worry about the file name - just look for any file in that...
September 26, 2013 at 8:55 am
That's rough. What are non-technical people doing even looking at code, never mind imposing standards for it?
John
September 26, 2013 at 8:21 am
Viewing 15 posts - 3,811 through 3,825 (of 7,185 total)