August 30, 2012 at 8:43 am
Fal (8/30/2012)
Brandie Tarvin (8/29/2012)
dwain.c (8/29/2012)
Jo Pattyn (8/29/2012)
How to inform developers that there are still slow/congested networks out there? About select * from remotesnailnetwork.matter.listed.particle finding one specific particle without a where clause. QoS?*edit* Not an actual situation, just some brainstorming
Set an example by burning one at the stake. That usually results in compliance by the rest and no recidivism. 🙂
Bad idea. Unless the others are around, they won't know about the example. Better to tar and feather one, so he's still alive to spread the word.
What's more, if the other are around then they're likely to spontaneously form a democracy and put your "suggestion" to a vote. And I've yet to work in a place with more database dudes than developers.
Steve.
I actually read the question differently. I took it as, "How do I monitor for and fire an alert (sent to a group of developers) when we are having network speed issues?". The query provided looked like a link server, so I assumed that they were trying to monitor the speed across that connection using a short simple query that should resolve within a set timeframe. I can also see how it could have meant, "How do I explain to developers that they need to consider network traffic and congestion when writing a query - using a query without a where clause to look for one specific row creates an enormous amount of unnecessary traffic that impacts everything else on the wire", which is what I think everyone else understood it to be. Jo - which question is closer to what you wanted?
August 30, 2012 at 9:45 am
Jo,
Sorry. We went off on a tangent, as we are wont to do on The Thread.
Please let us know which version of the question you were asking and we'll see if we can come up with a proper answer for you.
In the meantime, I'm heating up the tar just in case you need a barrel of it.
August 30, 2012 at 10:37 am
Brandie Tarvin (8/29/2012)
dwain.c (8/29/2012)
Jo Pattyn (8/29/2012)
How to inform developers that there are still slow/congested networks out there? About select * from remotesnailnetwork.matter.listed.particle finding one specific particle without a where clause. QoS?*edit* Not an actual situation, just some brainstorming
Set an example by burning one at the stake. That usually results in compliance by the rest and no recidivism. 🙂
Bad idea. Unless the others are around, they won't know about the example. Better to tar and feather one, so he's still alive to spread the word.
The smell will normally get to the others quick enough. 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
August 30, 2012 at 11:08 am
Chad, glad you read it differently, but I meant version B (teaching developers).
Like "You exceeded your network quota",please report to your system administrator to man the networkpump. Type a line, press button X located on the other side of the building to continue.
Something like raw materials.
August 30, 2012 at 11:08 am
Jeff Moden (8/30/2012)
Brandie Tarvin (8/29/2012)
dwain.c (8/29/2012)
Jo Pattyn (8/29/2012)
How to inform developers that there are still slow/congested networks out there? About select * from remotesnailnetwork.matter.listed.particle finding one specific particle without a where clause. QoS?*edit* Not an actual situation, just some brainstorming
Set an example by burning one at the stake. That usually results in compliance by the rest and no recidivism. 🙂
Bad idea. Unless the others are around, they won't know about the example. Better to tar and feather one, so he's still alive to spread the word.
The smell will normally get to the others quick enough. 😛
Puts a whole new perspective on the concept of "code smells".
----------------------------------------------------------------------------------
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?
August 30, 2012 at 11:21 am
Jo Pattyn (8/30/2012)
Chad, glad you read it differently, but I meant version B (teaching developers).Like "You exceeded your network quota",please report to your system administrator to man the networkpump. Type a line, press button X located on the other side of the building to continue.
Something like raw materials.
That's what unit testing should be used for. And PerfMon in a non-production environment. Do you have a QA team?
August 30, 2012 at 3:21 pm
Hey guys, need a hand with a deadlock issue. Short version: Heap table with no indexing and a single default constraint causing IX - X table level lock conflicts between an insert and an update. I have no idea how that even can occur, so either I'm misreading the graph or I'm swimmin' in the deep end again.
http://www.sqlservercentral.com/Forums/Topic1352470-360-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 30, 2012 at 6:34 pm
Jeff Moden (8/30/2012)
Brandie Tarvin (8/29/2012)
dwain.c (8/29/2012)
Jo Pattyn (8/29/2012)
How to inform developers that there are still slow/congested networks out there? About select * from remotesnailnetwork.matter.listed.particle finding one specific particle without a where clause. QoS?*edit* Not an actual situation, just some brainstorming
Set an example by burning one at the stake. That usually results in compliance by the rest and no recidivism. 🙂
Bad idea. Unless the others are around, they won't know about the example. Better to tar and feather one, so he's still alive to spread the word.
The smell will normally get to the others quick enough. 😛
Ah yes. The smell of a good barbeque always draws me in.
Call me whatever you want just don't call me late for dinner! 😛
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
August 31, 2012 at 12:35 pm
dwain.c (8/30/2012)
Jeff Moden (8/30/2012)
Brandie Tarvin (8/29/2012)
dwain.c (8/29/2012)
Jo Pattyn (8/29/2012)
How to inform developers that there are still slow/congested networks out there? About select * from remotesnailnetwork.matter.listed.particle finding one specific particle without a where clause. QoS?*edit* Not an actual situation, just some brainstorming
Set an example by burning one at the stake. That usually results in compliance by the rest and no recidivism. 🙂
Bad idea. Unless the others are around, they won't know about the example. Better to tar and feather one, so he's still alive to spread the word.
The smell will normally get to the others quick enough. 😛
Ah yes. The smell of a good barbeque always draws me in.
Call me whatever you want just don't call me late for dinner! 😛
We talking food again?
I'll have a ribeye
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 31, 2012 at 12:40 pm
dwain.c (8/30/2012)
Jeff Moden (8/30/2012)
Brandie Tarvin (8/29/2012)
dwain.c (8/29/2012)
Jo Pattyn (8/29/2012)
How to inform developers that there are still slow/congested networks out there? About select * from remotesnailnetwork.matter.listed.particle finding one specific particle without a where clause. QoS?*edit* Not an actual situation, just some brainstorming
Set an example by burning one at the stake. That usually results in compliance by the rest and no recidivism. 🙂
Bad idea. Unless the others are around, they won't know about the example. Better to tar and feather one, so he's still alive to spread the word.
The smell will normally get to the others quick enough. 😛
Ah yes. The smell of a good barbeque always draws me in.
Call me whatever you want just don't call me late for dinner! 😛
Then you need to get one of these bikes (see attachment).
_______________________________________________________________
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 31, 2012 at 12:56 pm
Sean Lange (8/31/2012)
dwain.c (8/30/2012)
Jeff Moden (8/30/2012)
Brandie Tarvin (8/29/2012)
dwain.c (8/29/2012)
Jo Pattyn (8/29/2012)
How to inform developers that there are still slow/congested networks out there? About select * from remotesnailnetwork.matter.listed.particle finding one specific particle without a where clause. QoS?*edit* Not an actual situation, just some brainstorming
Set an example by burning one at the stake. That usually results in compliance by the rest and no recidivism. 🙂
Bad idea. Unless the others are around, they won't know about the example. Better to tar and feather one, so he's still alive to spread the word.
The smell will normally get to the others quick enough. 😛
Ah yes. The smell of a good barbeque always draws me in.
Call me whatever you want just don't call me late for dinner! 😛
Then you need to get one of these bikes (see attachment).
BBQ everyday while commuting to work
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 31, 2012 at 1:04 pm
SQLRNNR (8/31/2012)
Sean Lange (8/31/2012)
dwain.c (8/30/2012)
Jeff Moden (8/30/2012)
Brandie Tarvin (8/29/2012)
dwain.c (8/29/2012)
Jo Pattyn (8/29/2012)
How to inform developers that there are still slow/congested networks out there? About select * from remotesnailnetwork.matter.listed.particle finding one specific particle without a where clause. QoS?*edit* Not an actual situation, just some brainstorming
Set an example by burning one at the stake. That usually results in compliance by the rest and no recidivism. 🙂
Bad idea. Unless the others are around, they won't know about the example. Better to tar and feather one, so he's still alive to spread the word.
The smell will normally get to the others quick enough. 😛
Ah yes. The smell of a good barbeque always draws me in.
Call me whatever you want just don't call me late for dinner! 😛
Then you need to get one of these bikes (see attachment).
BBQ everyday while commuting to work
That would be pretty awesome. I wish I had one. I will have to suffer with my "little" smoker (see attachment). I have determined that no matter how I arrange them I can't fit more than 26 slabs of baby backs at any 1 time. :w00t: The left side gets too hot for meat so I can only cook on the right side. I have done beans, baked potatoes and a few other things on the left side where the higher temperature doesn't hurt anything.
_______________________________________________________________
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 31, 2012 at 2:00 pm
Sean Lange (8/31/2012)
SQLRNNR (8/31/2012)
Sean Lange (8/31/2012)
dwain.c (8/30/2012)
Jeff Moden (8/30/2012)
Brandie Tarvin (8/29/2012)
dwain.c (8/29/2012)
Jo Pattyn (8/29/2012)
How to inform developers that there are still slow/congested networks out there? About select * from remotesnailnetwork.matter.listed.particle finding one specific particle without a where clause. QoS?*edit* Not an actual situation, just some brainstorming
Set an example by burning one at the stake. That usually results in compliance by the rest and no recidivism. 🙂
Bad idea. Unless the others are around, they won't know about the example. Better to tar and feather one, so he's still alive to spread the word.
The smell will normally get to the others quick enough. 😛
Ah yes. The smell of a good barbeque always draws me in.
Call me whatever you want just don't call me late for dinner! 😛
Then you need to get one of these bikes (see attachment).
BBQ everyday while commuting to work
That would be pretty awesome. I wish I had one. I will have to suffer with my "little" smoker (see attachment). I have determined that no matter how I arrange them I can't fit more than 26 slabs of baby backs at any 1 time. :w00t: The left side gets too hot for meat so I can only cook on the right side. I have done beans, baked potatoes and a few other things on the left side where the higher temperature doesn't hurt anything.
Maybe you could do some millionaire bacon on the left side?
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 31, 2012 at 2:14 pm
SQLRNNR (8/31/2012)
Sean Lange (8/31/2012)
SQLRNNR (8/31/2012)
Sean Lange (8/31/2012)
dwain.c (8/30/2012)
Jeff Moden (8/30/2012)
Brandie Tarvin (8/29/2012)
dwain.c (8/29/2012)
Jo Pattyn (8/29/2012)
How to inform developers that there are still slow/congested networks out there? About select * from remotesnailnetwork.matter.listed.particle finding one specific particle without a where clause. QoS?*edit* Not an actual situation, just some brainstorming
Set an example by burning one at the stake. That usually results in compliance by the rest and no recidivism. 🙂
Bad idea. Unless the others are around, they won't know about the example. Better to tar and feather one, so he's still alive to spread the word.
The smell will normally get to the others quick enough. 😛
Ah yes. The smell of a good barbeque always draws me in.
Call me whatever you want just don't call me late for dinner! 😛
Then you need to get one of these bikes (see attachment).
BBQ everyday while commuting to work
That would be pretty awesome. I wish I had one. I will have to suffer with my "little" smoker (see attachment). I have determined that no matter how I arrange them I can't fit more than 26 slabs of baby backs at any 1 time. :w00t: The left side gets too hot for meat so I can only cook on the right side. I have done beans, baked potatoes and a few other things on the left side where the higher temperature doesn't hurt anything.
Maybe you could do some millionaire bacon on the left side?
yummy!!! That looks pretty good.
Here is my counter before cooking (raw.jpg) and just before I wrapped the ribs in foil (AlmostDone.jpg). This was at the last big yard party this summer.
_______________________________________________________________
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/
Viewing 15 posts - 37,666 through 37,680 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply