August 7, 2014 at 11:24 am
Sean Lange (8/7/2014)
SQLRNNR (8/7/2014)
Jack Corbett (8/7/2014)
Lynn Pettis (8/7/2014)
SQLRNNR (8/7/2014)
Lynn Pettis (8/7/2014)
Now this just pissed me off:********* (8/7/2014)
thanks lynn, for being forthcoming (finally!)Leaving out the name of the perp.
Haha - too easy to find. :crazy:
At least I'm being civil and not responding directly. Not worth getting into an argument with this person.
I'm not sure how your first answer wasn't forthcoming enough. It should have been marked as the answer. In fact, it was probably a perfect answer for StackOverflow 😀 (yes, I've read all the posts in The Thread)
I was wondering that same thing.
My SSC sleuthing is failing me...I can't find it. :blush:
d'oh
Look at Lynn's previous comment about division.
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
August 7, 2014 at 11:32 am
SQLRNNR (8/7/2014)
Sean Lange (8/7/2014)
SQLRNNR (8/7/2014)
Jack Corbett (8/7/2014)
Lynn Pettis (8/7/2014)
SQLRNNR (8/7/2014)
Lynn Pettis (8/7/2014)
Now this just pissed me off:********* (8/7/2014)
thanks lynn, for being forthcoming (finally!)Leaving out the name of the perp.
Haha - too easy to find. :crazy:
At least I'm being civil and not responding directly. Not worth getting into an argument with this person.
I'm not sure how your first answer wasn't forthcoming enough. It should have been marked as the answer. In fact, it was probably a perfect answer for StackOverflow 😀 (yes, I've read all the posts in The Thread)
I was wondering that same thing.
My SSC sleuthing is failing me...I can't find it. :blush:
d'oh
Look at Lynn's previous comment about division.
Lynn, your answer IS correct and there's no argument to be made. Them being obstinate and snide, however, you can't fix. Put them in the same boat as WC.
August 7, 2014 at 11:50 am
SQLRNNR (8/7/2014)
Sean Lange (8/7/2014)
SQLRNNR (8/7/2014)
Jack Corbett (8/7/2014)
Lynn Pettis (8/7/2014)
SQLRNNR (8/7/2014)
Lynn Pettis (8/7/2014)
Now this just pissed me off:********* (8/7/2014)
thanks lynn, for being forthcoming (finally!)Leaving out the name of the perp.
Haha - too easy to find. :crazy:
At least I'm being civil and not responding directly. Not worth getting into an argument with this person.
I'm not sure how your first answer wasn't forthcoming enough. It should have been marked as the answer. In fact, it was probably a perfect answer for StackOverflow 😀 (yes, I've read all the posts in The Thread)
I was wondering that same thing.
My SSC sleuthing is failing me...I can't find it. :blush:
d'oh
Look at Lynn's previous comment about division.
Oh good grief. I had looked at that thread and somehow missed that. It was the perfect answer here and SO. There just isn't a lot more you can say about it. Of course at SO it would have been flagged as a duplicate and downvoted because else asked the same thing about 4 years ago.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 7, 2014 at 1:04 pm
I think I'm having an ESL problem. Can someone stick their head into this thread and see if I'm just not asking the right question or if they can rephrase it somehow?
http://www.sqlservercentral.com/Forums/Topic1600801-391-1.aspx
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 7, 2014 at 1:04 pm
Ed Wagner (8/7/2014)
Put them in the same boat as WC.
Speaking of... If you tried running a query against a table (a simple select) and if never returned, what would you consider first?
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
August 7, 2014 at 1:08 pm
GilaMonster (8/7/2014)
Ed Wagner (8/7/2014)
Put them in the same boat as WC.Speaking of... If you tried running a query against a table (a simple select) and if never returned, what would you consider first?
The table never existed.:-D:-D
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
August 7, 2014 at 1:09 pm
GilaMonster (8/7/2014)
Ed Wagner (8/7/2014)
Put them in the same boat as WC.Speaking of... If you tried running a query against a table (a simple select) and if never returned, what would you consider first?
Hung transaction in another spid, my SAN controller took a crap again and forgot to let SQL Server know, or I missed the where clause when I highlighted and F5'd so it's yanking back a few terabytes of data.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 7, 2014 at 1:24 pm
GilaMonster (8/7/2014)
Ed Wagner (8/7/2014)
Put them in the same boat as WC.Speaking of... If you tried running a query against a table (a simple select) and if never returned, what would you consider first?
Obviously the sql service is hung so just go to the server room and flip the switch on whole rack, just to be sure I got the power off for the server in question.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 7, 2014 at 1:34 pm
Sean Lange (8/7/2014)
GilaMonster (8/7/2014)
Ed Wagner (8/7/2014)
Put them in the same boat as WC.Speaking of... If you tried running a query against a table (a simple select) and if never returned, what would you consider first?
Obviously the sql service is hung so just go to the server room and flip the switch on whole rack, just to be sure I got the power off for the server in question.
what, you don't have the keys to the fuse box?
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
August 7, 2014 at 1:40 pm
jcrawf02 (8/7/2014)
Sean Lange (8/7/2014)
GilaMonster (8/7/2014)
Ed Wagner (8/7/2014)
Put them in the same boat as WC.Speaking of... If you tried running a query against a table (a simple select) and if never returned, what would you consider first?
Obviously the sql service is hung so just go to the server room and flip the switch on whole rack, just to be sure I got the power off for the server in question.
what, you don't have the keys to the fuse box?
Oddly enough...the server rooms are locked up pretty tight. However the main fuse boxes for the building are open to anybody who knows where they are. We are big production facility so I could literally turn off the entire production plant (~100 workers per shift) by simply flipping the switch. 😛
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 7, 2014 at 1:42 pm
Sean Lange (8/7/2014)
jcrawf02 (8/7/2014)
Sean Lange (8/7/2014)
GilaMonster (8/7/2014)
Ed Wagner (8/7/2014)
Put them in the same boat as WC.Speaking of... If you tried running a query against a table (a simple select) and if never returned, what would you consider first?
Obviously the sql service is hung so just go to the server room and flip the switch on whole rack, just to be sure I got the power off for the server in question.
what, you don't have the keys to the fuse box?
Oddly enough...the server rooms are locked up pretty tight. However the main fuse boxes for the building are open to anybody who knows where they are. We are big production facility so I could literally turn off the entire production plant (~100 workers per shift) by simply flipping the switch. 😛
Sounds like somebody has had his fun on April Fools on a few occasions.
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
August 7, 2014 at 1:48 pm
SQLRNNR (8/7/2014)
Sean Lange (8/7/2014)
jcrawf02 (8/7/2014)
Sean Lange (8/7/2014)
GilaMonster (8/7/2014)
Ed Wagner (8/7/2014)
Put them in the same boat as WC.Speaking of... If you tried running a query against a table (a simple select) and if never returned, what would you consider first?
Obviously the sql service is hung so just go to the server room and flip the switch on whole rack, just to be sure I got the power off for the server in question.
what, you don't have the keys to the fuse box?
Oddly enough...the server rooms are locked up pretty tight. However the main fuse boxes for the building are open to anybody who knows where they are. We are big production facility so I could literally turn off the entire production plant (~100 workers per shift) by simply flipping the switch. 😛
Sounds like somebody has had his fun on April Fools on a few occasions.
Nah. I don't balls that big. This isn't the kind of switch you could accidentally turn off. It is a large handle that would require doing this intentionally. Although I suppose I can do whatever on my last day. 🙂
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 7, 2014 at 1:52 pm
GilaMonster (8/7/2014)
Ed Wagner (8/7/2014)
Put them in the same boat as WC.Speaking of... If you tried running a query against a table (a simple select) and if never returned, what would you consider first?
I would abort the query long before "never" arrived and look for my missing join that I forgot to include. Not finding that, I would consider a blocking process. I guess I'd make sure I can select 1 row from each table and that would tell me where to go next.
August 7, 2014 at 2:18 pm
Ok, good, I'm not the only one who would think 'blocking' long before thinking 'let me post this impossible situation on the forums'
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
August 7, 2014 at 2:21 pm
GilaMonster (8/7/2014)
Ok, good, I'm not the only one who would think 'blocking' long before thinking 'let me post this impossible situation on the forums'
Oh blocking, yeah that must have been the problem :hehe::hehe:
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
Viewing 15 posts - 45,121 through 45,135 (of 66,549 total)
You must be logged in to reply to this topic. Login to reply