Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 37,681 through 37,695 (of 66,712 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Sean Lange (8/31/2012)
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.

I'm drooling. And i'm hungry

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

Sean Lange SSC Guru Points: 286590 More actions · Answer 2

SQLRNNR (8/31/2012)
Sean Lange (8/31/2012)
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.
I'm drooling. And i'm hungry

Come on over. I stuck 2 slabs of the Orange Chipotle ribs in the freezer. They should be thawed by the second of third beer.

_______________________________________________________________

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/

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 3

Sean Lange (8/31/2012)
SQLRNNR (8/31/2012)
Sean Lange (8/31/2012)
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.
I'm drooling. And i'm hungry
Come on over. I stuck 2 slabs of the Orange Chipotle ribs in the freezer. They should be thawed by the second of third beer.

Unfortunately I'm not as cool as you guys and don't have a smoker, but you did get me to break out the LLoyd's Ribs for lunch. 🙂 *gnaw gnaw gnaw gnaw*

- Craig Farrell

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

Sean Lange (8/31/2012)
SQLRNNR (8/31/2012)
Sean Lange (8/31/2012)
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.
I'm drooling. And i'm hungry
Come on over. I stuck 2 slabs of the Orange Chipotle ribs in the freezer. They should be thawed by the second of third beer.

Phoenix, right?;-)

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

Sean Lange SSC Guru Points: 286590 More actions · Answer 5

Evil Kraig F (8/31/2012)
Unfortunately I'm not as cool as you guys and don't have a smoker, but you did get me to break out the LLoyd's Ribs for lunch. 🙂 *gnaw gnaw gnaw gnaw*

ROFL!!! Cool has not been used in the same sentence as me without the word NOT in a very long time!!!

_______________________________________________________________

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/

Sean Lange SSC Guru Points: 286590 More actions · Answer 6

SQLRNNR (8/31/2012)
Phoenix, right?;-)

Kansas City

_______________________________________________________________

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/

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

Sean Lange (8/31/2012)
SQLRNNR (8/31/2012)
Phoenix, right?;-)
Kansas City

Only missed it by 1000 or so miles.:-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

Sean Lange SSC Guru Points: 286590 More actions · Answer 8

SQLRNNR (8/31/2012)
Sean Lange (8/31/2012)
SQLRNNR (8/31/2012)
Phoenix, right?;-)
Kansas City
Only missed it by 1000 or so miles.:-D

But it probably does explain the Kansas City Sporting logo as my avatar. 🙂

_______________________________________________________________

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/

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

Sean Lange (8/31/2012)
SQLRNNR (8/31/2012)
Sean Lange (8/31/2012)
SQLRNNR (8/31/2012)
Phoenix, right?;-)
Kansas City
Only missed it by 1000 or so miles.:-D
But it probably does explain the Kansas City Sporting logo as my avatar. 🙂

Is that what that is? All I could tell was "Sporting"

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

Sean Lange SSC Guru Points: 286590 More actions · Answer 10

SQLRNNR (8/31/2012)
Sean Lange (8/31/2012)
SQLRNNR (8/31/2012)
Sean Lange (8/31/2012)
SQLRNNR (8/31/2012)
Phoenix, right?;-)
Kansas City
Only missed it by 1000 or so miles.:-D
But it probably does explain the Kansas City Sporting logo as my avatar. 🙂
Is that what that is? All I could tell was "Sporting"

Yeah it looks pretty bad when it is that small.

_______________________________________________________________

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/

SQLRNNR SSC Guru Points: 281334 More actions · Answer 11

Sean Lange (8/31/2012)
SQLRNNR (8/31/2012)
Sean Lange (8/31/2012)
SQLRNNR (8/31/2012)
Sean Lange (8/31/2012)
SQLRNNR (8/31/2012)
Phoenix, right?;-)
Kansas City
Only missed it by 1000 or so miles.:-D
But it probably does explain the Kansas City Sporting logo as my avatar. 🙂
Is that what that is? All I could tell was "Sporting"
Yeah it looks pretty bad when it is that small.

I see it now. Yeah, that makes a little more sense 😎

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

WayneS SSC Guru Points: 95460 More actions · Answer 12

Hey Threadizens - I'm having an issue shredding some xml (a deadlock graph) - one query gets the info, but another doesn't. If you feel like taking on this challenge, complete details are over here.

Edit: on a related note - does anyone have a deadlock graph (XML) with either the threadpool or resourceWait events in it?

Thanks!

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

TomThomson SSC Guru Points: 104773 More actions · Answer 13

dwain.c (8/21/2012)
GilaMonster (8/21/2012)
<soapbox>
Cursors are tools. Use them where they work, don't use them where they don't. Statements like 'you should never use a <whatever>' are just shortsighted
If we count while loops as cursors, I wrote about 10 since saturday
Rest assured that if I ever encounter a case where a CURSOR out-performs a set based solution, I'll happily use it. In this case, I believe a rewrite without inner the CURSOR will probably be faster. The logic may be too complex to eliminate the outer CURSOR.

As long as you know how to measure performance (is faster the real performance requirement here, for example?). Remember than human time is quite expensive, while machine time is quite cheap; and trade-offs between elapsed time (whether development time or run time) and utilisation (whether of people or of networks or of processors or of storage devices) are often sufficiently interesting to give you a real headache.

I have written some WHILE loops but they don't count.

Why not? Of course they don't use that word "cursor" but they are iterative rather than set-oriented, which surely is the sensible objection to cursors that leads to silly statements like that "write no more than 5 in your career" one.

Tom

Fal Hall of Fame Points: 3143 More actions · Answer 14

Quick poll: how would you pronounce the word "Route"?

I'll explain why later, if I'm not too embarrassed. :blink:

Steve.

Paul White SSC Guru Points: 150467 More actions · Answer 15

Fal (9/3/2012)
Quick poll: how would you pronounce the word "Route"?

I try to avoid the word completely, using a synonym or rephrasing the whole statement. Pronouncing it 'rowt' has never seemed natural to me (despite the number of American shows we get) though it is undoubtedly safer than 'root'.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi