Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««3,9603,9613,9623,9633,964»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Sunday, May 5, 2013 11:28 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 2:17 PM
Points: 53, Visits: 161
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...
Post #1449537
Posted Sunday, May 5, 2013 11:34 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:44 PM
Points: 21,209, Visits: 14,899
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 think
http://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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1449538
Posted Sunday, May 5, 2013 11:36 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:44 PM
Points: 21,209, Visits: 14,899
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1449539
Posted Sunday, May 5, 2013 4:38 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 12:52 AM
Points: 21,385, Visits: 9,601
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 think
http://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".
Post #1449546
Posted Sunday, May 5, 2013 9:44 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 10:27 AM
Points: 23,009, Visits: 31,500
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 think
http://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.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1449571
Posted Monday, May 6, 2013 5:14 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 6:57 AM
Points: 357, Visits: 2,249
Lynn Pettis (5/5/2013)
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 think
http://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.


I threw a few queries into google and I didn't immediately get an answer. I'm sure theres a google search term that would throw back a link to a simple explanation, but I'm not so sure its an obvious one. Maybe he tried a few search terms, got unsatisfactory results, and popped in here to post a query. Being concerned about getting locked out is a fairly common pattern, and if he isn't routinely in a server administrator role, I could see him being unfamiliar with the command usage and subsequently hopping on here and tossing a question out before even using the command. It is not an abuse of anybody's time here on his part, I've never seen an impolite word from him, and I'm sure he didn't expect this sort of behavior from you guys as a result of him posting such a harmless question. I know I wouldn't have expected it.
Post #1449659
Posted Monday, May 6, 2013 5:23 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 9:11 AM
Points: 7,128, Visits: 6,291
Ninja's_RGR'us (5/5/2013)
That question was ANYTHING but trivial.

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).


I have to agree with Ninja on this. We have an application domain account that keeps logging back onto our databases when it loses connection, so I could very easily run into this problem. I get kicked off, suddenly the app account (which isn't a person account) logs into the database and now I can't get back in?

Absolutely I can see this pain coming. Absolutely I see it not being a trival question.


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1449664
Posted Monday, May 6, 2013 5:49 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 9:10 AM
Points: 1,211, Visits: 6,541
Brandie Tarvin (5/6/2013)
Ninja's_RGR'us (5/5/2013)
That question was ANYTHING but trivial.

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).


I have to agree with Ninja on this. We have an application domain account that keeps logging back onto our databases when it loses connection, so I could very easily run into this problem. I get kicked off, suddenly the app account (which isn't a person account) logs into the database and now I can't get back in?

Absolutely I can see this pain coming. Absolutely I see it not being a trival question.


Hopefully that app account is something other than SA and is a domain account.
And if the backend db is expected to be down, and this is a web application, I usually shut the web site down to aboid this.
But you may not have that luxury.
Post #1449677
Posted Monday, May 6, 2013 6:05 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 9:11 AM
Points: 7,128, Visits: 6,291
Greg Edwards-268690 (5/6/2013)
Brandie Tarvin (5/6/2013)
Ninja's_RGR'us (5/5/2013)
That question was ANYTHING but trivial.

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).


I have to agree with Ninja on this. We have an application domain account that keeps logging back onto our databases when it loses connection, so I could very easily run into this problem. I get kicked off, suddenly the app account (which isn't a person account) logs into the database and now I can't get back in?

Absolutely I can see this pain coming. Absolutely I see it not being a trival question.


Hopefully that app account is something other than SA and is a domain account.


Well, duh. @=)


And if the backend db is expected to be down, and this is a web application, I usually shut the web site down to aboid this.
But you may not have that luxury.


We don't. The app account is used for multiple applications, only some of them web apps. To be clear though, I haven't actually run into this problem. I'm just saying that I totally get why the OP is freaking out about it because if I did run into this problem, I'd be freaking out too.


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1449681
Posted Monday, May 6, 2013 7:01 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 10:27 AM
Points: 23,009, Visits: 31,500
Brandie Tarvin (5/6/2013)
Ninja's_RGR'us (5/5/2013)
That question was ANYTHING but trivial.

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).


I have to agree with Ninja on this. We have an application domain account that keeps logging back onto our databases when it loses connection, so I could very easily run into this problem. I get kicked off, suddenly the app account (which isn't a person account) logs into the database and now I can't get back in?

Absolutely I can see this pain coming. Absolutely I see it not being a trival question.


Well, after rereading the question, hard to say. It is very short on any facts appearing to be more of a what if than I just had this happen to me, and if it was a just happened to me there is nothing to say what he had done to try and correct the the problem before coming here.

Hate to say it, but looks to me like a lack of initiative and/or problem solving skills. Both critical skills to the work that we do on a day to day basis. And this appears to be a person who has been working with SQL Server for about 8 years.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1449701
« Prev Topic | Next Topic »

Add to briefcase «««3,9603,9613,9623,9633,964»»»

Permissions Expand / Collapse