January 15, 2010 at 9:36 am
tosscrosby-60625 (1/15/2010)
Gail, you know the answer, give the users the ability to kill the offending SPID! Clean and simple solution to keep things quiet while the OP searches madly for a new job to escape the hell he/she has gotten into!!http://www.sqlservercentral.com/Forums/Topic844144-1291-1.aspx#bm844310
Nice thing about deadlocks is that SQL does all the killing for you. The offending SPID goes away and your hands can stay clean.
Hmm, that means that deadlocks aren't a problem. After all, SQL takes care of them.
Thanks Terry, that means I have a lot less to do this weekend.
😀 😉
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 15, 2010 at 1:02 pm
Lynn Pettis (1/15/2010)
Love you must the easy ones.
nice
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 16, 2010 at 1:33 am
I had one of those earlier in the week.
OP: Why is my database still Restoring... almost a day later?
Me: Because you ran the restore WITH NORECOVERY
OP: Oh.
I mentioned it on Twitter (just generic comment), hour later I got a reply from someone telling me (incorrectly) how to bring my DB out of recovery.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 16, 2010 at 9:55 am
I guess that Twitter SQL help thing is going to work out great, isn't it?
January 16, 2010 at 10:20 am
Steve Jones - Editor (1/16/2010)
I guess that Twitter SQL help thing is going to work out great, isn't it?
Can't help but think that the amount of help you can provide in 140 characters would be a limiting factor, especially when the issue is "urgent".... 🙂
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
January 16, 2010 at 10:30 am
Matt Miller (#4) (1/16/2010)
Steve Jones - Editor (1/16/2010)
I guess that Twitter SQL help thing is going to work out great, isn't it?Can't help but think that the amount of help you can provide in 140 characters would be a limiting factor, especially when the issue is "urgent".... 🙂
Precisely. Also hard to read intent. Especially when people are rushing to be *the* person who answered the question.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 19, 2010 at 7:58 am
Something tells me we lost several days of posts on the THREAD??????
-- You can't be late until you show up.
January 19, 2010 at 8:04 am
Not much action in THE THREAD this year.... hmmm I wonder what is happening..
-Roy
January 19, 2010 at 8:15 am
Work is getting in the way.
Greg E
January 19, 2010 at 8:19 am
Roy Ernest (1/19/2010)
Not much action in THE THREAD this year.... hmmm I wonder what is happening..
I think it may be related to the length of the ladder that leads to the end of the thread getting longer and longer. It's not everybody that can handle that long climb.
😀
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
January 19, 2010 at 8:25 am
Five days of inactivity seemed a little much and I really hadn't been checking with my usual regularity so, as is my nature, I assumed the worst. And, believe me, I know about the work getting in the way. Been like this since just before the holidays although it is starting to let up a bit.
-- You can't be late until you show up.
January 19, 2010 at 8:29 am
True it is that work is prohibiting a lot of thread activity. I wonder also if there is some interference from New Years resolutions and goals too. Everybody trying to get those goals accomplished early in the year, maybe?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 19, 2010 at 9:43 am
Work, work, lots of work. I'm barely posting at all these days either.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 10,621 through 10,635 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply