May 3, 2013 at 11:48 am
Evil Kraig F (5/2/2013)
Well, true enough. 😀 However, its purpose on my wall is not as a reference, but to deter some overly optimistic folks about just how important their five minute monthly report is. 😉
Wonderful.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
May 4, 2013 at 3:14 pm
May the fourth
be with you
---------------------------------------------------------------------
May 4, 2013 at 3:30 pm
Err... I don't know what to think
http://www.sqlservercentral.com/Forums/Topic1449451-1550-1.aspx
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
May 4, 2013 at 4:56 pm
GilaMonster (5/4/2013)
Err... I don't know what to thinkhttp://www.sqlservercentral.com/Forums/Topic1449451-1550-1.aspx
Well, it looks like they were happy with your answer, so there's that...
I'd bet the posters' first language isn't english...
Jason
May 4, 2013 at 6:56 pm
GilaMonster (5/4/2013)
Err... I don't know what to thinkhttp://www.sqlservercentral.com/Forums/Topic1449451-1550-1.aspx
And as long as he has been around you'd think he'd know this.
May 4, 2013 at 7:58 pm
Lynn Pettis (5/4/2013)
GilaMonster (5/4/2013)
Err... I don't know what to thinkhttp://www.sqlservercentral.com/Forums/Topic1449451-1550-1.aspx
And as long as he has been around you'd think he'd know this.
How many situations have you NEVER encountered?
A lot more than those you've been exposed to!
May 4, 2013 at 10:28 pm
Ninja's_RGR'us (5/4/2013)
Lynn Pettis (5/4/2013)
GilaMonster (5/4/2013)
Err... I don't know what to thinkhttp://www.sqlservercentral.com/Forums/Topic1449451-1550-1.aspx
And as long as he has been around you'd think he'd know this.
How many situations have you NEVER encountered?
A lot more than those you've been exposed to!
Some situations just require a little though and investigation, and this was one.
May 4, 2013 at 10:32 pm
Lynn Pettis (5/4/2013)
Ninja's_RGR'us (5/4/2013)
Lynn Pettis (5/4/2013)
GilaMonster (5/4/2013)
Err... I don't know what to thinkhttp://www.sqlservercentral.com/Forums/Topic1449451-1550-1.aspx
And as long as he has been around you'd think he'd know this.
How many situations have you NEVER encountered?
A lot more than those you've been exposed to!
Some situations just require a little thought and investigation, and this was one.
May 4, 2013 at 10:54 pm
Ninja's_RGR'us (5/4/2013)
Lynn Pettis (5/4/2013)
GilaMonster (5/4/2013)
Err... I don't know what to thinkhttp://www.sqlservercentral.com/Forums/Topic1449451-1550-1.aspx
And as long as he has been around you'd think he'd know this.
How many situations have you NEVER encountered?
A lot more than those you've been exposed to!
Well, that thread and these comments made me think "Why not create a short blog blurb on it"
So I did
I know of several people that would do the same thing as posted in that thread.
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
May 5, 2013 at 6:02 am
Ninja's_RGR'us (5/4/2013)
Lynn Pettis (5/4/2013)
GilaMonster (5/4/2013)
Err... I don't know what to thinkhttp://www.sqlservercentral.com/Forums/Topic1449451-1550-1.aspx
And as long as he has been around you'd think he'd know this.
How many situations have you NEVER encountered?
I've never encountered that particular situation.
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
May 5, 2013 at 11:28 am
I've most certainly (MOST CERTAINLY) asked my share of dumb questions, but...wouldn't you at least try logging in first? Okay, I had a laugh..it was good. Now I have to go post my own dumb question...
May 5, 2013 at 11:34 am
GilaMonster (5/5/2013)
Ninja's_RGR'us (5/4/2013)
Lynn Pettis (5/4/2013)
GilaMonster (5/4/2013)
Err... I don't know what to thinkhttp://www.sqlservercentral.com/Forums/Topic1449451-1550-1.aspx
And as long as he has been around you'd think he'd know this.
How many situations have you NEVER encountered?
I've never encountered that particular situation.
This illustrates that this issue like many others can be solved with a little logic and thought. One doesn't necessarily need to have experienced it to figure out how to resolve it.
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
May 5, 2013 at 11:36 am
dbursey (5/5/2013)
I've most certainly (MOST CERTAINLY) asked my share of dumb questions, but...wouldn't you at least try logging in first? Okay, I had a laugh..it was good. Now I have to go post my own dumb question...
Well some of us would try a few things first 😉
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
May 5, 2013 at 4:38 pm
SQLRNNR (5/5/2013)
GilaMonster (5/5/2013)
Ninja's_RGR'us (5/4/2013)
Lynn Pettis (5/4/2013)
GilaMonster (5/4/2013)
Err... I don't know what to thinkhttp://www.sqlservercentral.com/Forums/Topic1449451-1550-1.aspx
And as long as he has been around you'd think he'd know this.
How many situations have you NEVER encountered?
I've never encountered that particular situation.
This illustrates that this issue like many others can be solved with a little logic and thought. One doesn't necessarily need to have experienced it to figure out how to resolve it.
That question was ANYTHING but trivial.
What if he's planning his first big migration and never used that tool / setting? he has the ok to shut down that prod DB but can't shut down the server.
How does he back out if something goes wrong? What if someone steals is connection (by accident)? What if that program AUTO reconnects NON stop (like Navision).
Can you kill your own spid from that same connection?
If I log back in the same server on another DB, can I then kill the connection and switch context to take back control?
I've heard of DAC, could it work in this situation (and what's the main pitfall)... if so I'll take the time to study it.
What if this setting happens within a job that somehow gets killed or stopped by an unforseen event, how will I recover from that?
People come here for guidance. They need help with what they don't know they don't know. 99+% of the folks know how to google, use books online and their support group. You guys need to look past the words and understand what the ops are actually living (all the way up to how they feel).
That's how I stopped that guy from killing himself 2 years ago. Many of you were flat out ignoring him or making it worse by "not so useful comments".
May 5, 2013 at 9:44 pm
Ninja's_RGR'us (5/5/2013)
SQLRNNR (5/5/2013)
GilaMonster (5/5/2013)
Ninja's_RGR'us (5/4/2013)
Lynn Pettis (5/4/2013)
GilaMonster (5/4/2013)
Err... I don't know what to thinkhttp://www.sqlservercentral.com/Forums/Topic1449451-1550-1.aspx
And as long as he has been around you'd think he'd know this.
How many situations have you NEVER encountered?
I've never encountered that particular situation.
This illustrates that this issue like many others can be solved with a little logic and thought. One doesn't necessarily need to have experienced it to figure out how to resolve it.
That question was ANYTHING but trivial.
What if he's planning his first big migration and never used that tool / setting? he has the ok to shut down that prod DB but can't shut down the server.
How does he back out if something goes wrong? What if someone steals is connection (by accident)? What if that program AUTO reconnects NON stop (like Navision).
Can you kill your own spid from that same connection?
If I log back in the same server on another DB, can I then kill the connection and switch context to take back control?
I've heard of DAC, could it work in this situation (and what's the main pitfall)... if so I'll take the time to study it.
What if this setting happens within a job that somehow gets killed or stopped by an unforseen event, how will I recover from that?
People come here for guidance. They need help with what they don't know they don't know. 99+% of the folks know how to google, use books online and their support group. You guys need to look past the words and understand what the ops are actually living (all the way up to how they feel).
That's how I stopped that guy from killing himself 2 years ago. Many of you were flat out ignoring him or making it worse by "not so useful comments".
First, I am not aware of anyone trying to kill himself 2 years ago on ssc (of course I was working with Oracle then and not spending much time here during that time), and second it also comes from knowing the history of the poster.
Maybe it isn't trivial to the OP, but it is obvious that he did no research into the problem before posting the question. Tell me, when you run into something you have never experienced before, is the first thing you do jump on the internet on to a forum looking for help or do you start researching the issue trying to figure out what is happening (or happened) first then ask for help when you realize that you need additional guidance? I go for the later as I learn better from doing my own research first rather than just having someone give me the answer.
Viewing 15 posts - 39,601 through 39,615 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply