Viewing 15 posts - 4,591 through 4,605 (of 49,571 total)
Turn traceflag 1222 on. That will result in a deadlock graph being written to the error log.
October 6, 2015 at 11:07 pm
No.
If the procedure has been executed recently, and the plan is still in cache, then you can query sys.dm_exec_procedure_stats, but a procedure will only have an entry in there if...
October 6, 2015 at 1:11 pm
If you had restarted SQL, the rollback would have started again from the beginning, with the database offline and inaccessible until the rollback had completed. It's a good way to...
October 6, 2015 at 12:06 pm
Yes.
Though it's pretty useless to just say yes/no, as there are lots of caveats, limitations and considerations.
https://msdn.microsoft.com/en-za/library/ms191432.aspx
https://www.simple-talk.com/sql/learn-sql-server/sql-server-indexed-views-the-basics/
October 6, 2015 at 10:32 am
You can't put that into a loop. Do it the way you wrote in the second post, each variable explicitly assigned one by one.
October 6, 2015 at 10:23 am
#gloat Company's paying for the trip to the US. If I was speaking at Pass Summit, they'd be paying for hotel too. They paid for my trip to the Cape...
October 6, 2015 at 9:15 am
Ok, yeah, that's the plan compiling taking that time, assuming that it consistently takes 35 minutes run with recompile.
To be honest, not much you can really do. Maybe try to...
October 6, 2015 at 8:50 am
Are you sure it's the plan being cached that saves the time, and not the data being cached. Test with a warm data cache and the plan removed from cache,...
October 6, 2015 at 8:20 am
Markus (10/6/2015)
That just might be it.... when I look at her SPID SQL it shows the select... hum....
Yes, because the DMVs show the last statement that a session ran, or...
October 6, 2015 at 8:18 am
You could probably safely shrink it (once) to 175 or 200GB.
It can take a long time, but it's an online operation. I would recommend it be done out of main...
October 6, 2015 at 8:00 am
Unless she's starting a transaction and not committing (and making some form of data modifications in the transaction), closing the query tool is not necessary. In the absence of transactions,...
October 6, 2015 at 7:22 am
ps_vbdev (10/6/2015)
Your explanation makes total sense but where would the implicit conversation take place?
In your queries, if you're ever doing anything like
WHERE UserID = @ParameterOfTheUniqueidentifierType, or anything similar
And if...
October 6, 2015 at 6:54 am
Grant Fritchey (10/6/2015)
Unless they're starting a transaction and then walking away with it uncommitted.
Seen that happen before. Brought am entire application to a complete standstill on all users' machines.
If it...
October 6, 2015 at 6:35 am
Viewing 15 posts - 4,591 through 4,605 (of 49,571 total)