Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 18,196 through 18,210 (of 66,712 total)

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

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 1

LutzM (9/7/2010)
jcrawf02 (9/7/2010)
Do you suppose 5 minutes to return one row of data will be too much for end users? 😛
Now I just have to figure out what the hell I did to that query...
If you're working for a government project: not at all. You might even need to add a WAITFOR clause... :-D;-)
It is essential to allow government staff to prepare themselves for the answer to the question they carefully typed into the PC over the last couple of days.... 😀

Am I using it right? WAITFOR 'Friday at 5pm'

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

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 2

jcrawf02 (9/7/2010)
LutzM (9/7/2010)
jcrawf02 (9/7/2010)
Do you suppose 5 minutes to return one row of data will be too much for end users? 😛
Now I just have to figure out what the hell I did to that query...
If you're working for a government project: not at all. You might even need to add a WAITFOR clause... :-D;-)
It is essential to allow government staff to prepare themselves for the answer to the question they carefully typed into the PC over the last couple of days.... 😀
Am I using it right? WAITFOR 'Friday at 5pm'

Like this:

WAITFOR 'Steve out of cell phone range'

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 3

Steve Jones - Editor (9/7/2010)
jcrawf02 (9/7/2010)
LutzM (9/7/2010)
jcrawf02 (9/7/2010)
Do you suppose 5 minutes to return one row of data will be too much for end users? 😛
Now I just have to figure out what the hell I did to that query...
If you're working for a government project: not at all. You might even need to add a WAITFOR clause... :-D;-)
It is essential to allow government staff to prepare themselves for the answer to the question they carefully typed into the PC over the last couple of days.... 😀
Am I using it right? WAITFOR 'Friday at 5pm'
Like this:
WAITFOR 'Steve out of cell phone range'

Why so soon? Try:

WAITFOR 'Hell to freeze over'

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

WayneS SSC Guru Points: 95460 More actions · Answer 4

Steve Jones - Editor (9/7/2010)
jcrawf02 (9/7/2010)
LutzM (9/7/2010)
jcrawf02 (9/7/2010)
Do you suppose 5 minutes to return one row of data will be too much for end users? 😛
Now I just have to figure out what the hell I did to that query...
If you're working for a government project: not at all. You might even need to add a WAITFOR clause... :-D;-)
It is essential to allow government staff to prepare themselves for the answer to the question they carefully typed into the PC over the last couple of days.... 😀
Am I using it right? WAITFOR 'Friday at 5pm'
Like this:
WAITFOR 'Steve out of cell phone range'

Isn't that anywhere on the ranch? If not, you didn't get a rural enough place!;-)

Edit: quoted wrong message... 🙁

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

LutzM SSC Guru Points: 107049 More actions · Answer 5

jcrawf02 (9/7/2010)
LutzM (9/7/2010)
jcrawf02 (9/7/2010)
Do you suppose 5 minutes to return one row of data will be too much for end users? 😛
Now I just have to figure out what the hell I did to that query...
If you're working for a government project: not at all. You might even need to add a WAITFOR clause... :-D;-)
It is essential to allow government staff to prepare themselves for the answer to the question they carefully typed into the PC over the last couple of days.... 😀
Am I using it right? WAITFOR 'Friday at 5pm'

Wait a minute! If you're talking about government staff you'll most probably be safe with WAITFOR 'Friday at 1pm'

Or do you have a 2nd shift in your Gvmt facilities? We don't.

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 6

HAHAHA!!!

Hey, I just work with them, not for them, so I have to 'trust' them that when they say they'll be there, they'll be there. And then cope with them not being there when we have critical questions about the sanctions they're placing on us. 😉

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

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 7

The cell phone works at the ranch. Drops on the way out here, and if I walk across the property, I can see 3 different carriers at different places. Once I take a call, I've learned I have a limited distance I can wander around in.

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 8

LutzM (9/7/2010)
Steve Jones - Editor (9/7/2010)
WayneS (9/7/2010)
Looks like Lutz is having to pull teeth to get the OP to read how to help himself out.
Actually I picture Lutz as Wayne's avatar.
As long as you enjoy it, feel free to do so... 😀
I thought about getting more and more sarcastic but it seems like I'm learning not to.
So, actually, I'm learning something at the moment. I just don't know what it is yet....
But since Saint Lynn took over I can safely step back and watch him taking care of it.

lol yeah. "I didn't dismiss your query, I will run it". Tenses were never my strong suit either.

**EDIT - Damn Wayne, that's funny as hell. Time to go home, day can't get any better than that....

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

WayneS SSC Guru Points: 95460 More actions · Answer 9

jcrawf02 (9/7/2010)
LutzM (9/7/2010)
Steve Jones - Editor (9/7/2010)
WayneS (9/7/2010)
Looks like Lutz is having to pull teeth to get the OP to read how to help himself out.
Actually I picture Lutz as Wayne's avatar.
As long as you enjoy it, feel free to do so... 😀
I thought about getting more and more sarcastic but it seems like I'm learning not to.
So, actually, I'm learning something at the moment. I just don't know what it is yet....
But since Saint Lynn took over I can safely step back and watch him taking care of it.
lol yeah. "I didn't dismiss your query, I will run it". Tenses were never my strong suit either.
**EDIT - Damn Wayne, that's funny as hell. Time to go home, day can't get any better than that....

😎 (you talking about my select statement? I thought about running it against sys.columns...) :w00t:

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

WayneS SSC Guru Points: 95460 More actions · Answer 10

Steve Jones - Editor (9/7/2010)
WayneS (9/7/2010)
Looks like Lutz is having to pull teeth to get the OP to read how to help himself out.
Actually I picture Lutz as Wayne's avatar.

The way that thread is going, this is what I'm picturing Lutz as. (I wanted to use this as my avatar, but, well, I didn't figure it would go over too good!)

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

Ron McCullough SSC Guru Points: 63877 More actions · Answer 11

Steve Jones
Red Rocks is great.

Never been there but just slightly south of Colorado Springs is the Broadmoor resort complex ..... Always liked the "Golden Bee" that english bar transported from England and rebuilt at Broadmoor .... great enjoying a pint of English ale ... and dinning at the top of the original Broadmoor building .... what elegance, what luxury and the joy of it all .... on the expense account.

Steve ever hoisted one or more at the "Golden Bee"?

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 12

LutzM (9/7/2010)
jcrawf02 (9/7/2010)
LutzM (9/7/2010)
jcrawf02 (9/7/2010)
Do you suppose 5 minutes to return one row of data will be too much for end users? 😛
Now I just have to figure out what the hell I did to that query...
If you're working for a government project: not at all. You might even need to add a WAITFOR clause... :-D;-)
It is essential to allow government staff to prepare themselves for the answer to the question they carefully typed into the PC over the last couple of days.... 😀
Am I using it right? WAITFOR 'Friday at 5pm'
Wait a minute! If you're talking about government staff you'll most probably be safe with WAITFOR 'Friday at 1pm'
Or do you have a 2nd shift in your Gvmt facilities? We don't.

When speaking of the gov, wouldn't it be more appropriate to say something like:

WAITFOR 'Anytime - we're not working anyway'😛

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 13

Steve Jones - Editor (9/7/2010)
The cell phone works at the ranch. Drops on the way out here, and if I walk across the property, I can see 3 different carriers at different places. Once I take a call, I've learned I have a limited distance I can wander around in.

Funny - I am not in a rural area (fairly densely populated) with numerous cell towers and my house seems to be a prime deadzone - actually most of my neighborhood. Once we connect we have to remain in that same position for the duration or risk losing the call. A lot of phone on top of the filing cabinet, scrunched in the corner, elbow cocked awkwardly for a 2hr conference call.

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 14

WayneS (9/7/2010)
jcrawf02 (9/7/2010)
LutzM (9/7/2010)
Steve Jones - Editor (9/7/2010)
WayneS (9/7/2010)
Looks like Lutz is having to pull teeth to get the OP to read how to help himself out.
Actually I picture Lutz as Wayne's avatar.
As long as you enjoy it, feel free to do so... 😀
I thought about getting more and more sarcastic but it seems like I'm learning not to.
So, actually, I'm learning something at the moment. I just don't know what it is yet....
But since Saint Lynn took over I can safely step back and watch him taking care of it.
lol yeah. "I didn't dismiss your query, I will run it". Tenses were never my strong suit either.
**EDIT - Damn Wayne, that's funny as hell. Time to go home, day can't get any better than that....
😎 (you talking about my select statement? I thought about running it against sys.columns...) :w00t:

Reading that thread - I think all suggestions were simply dismissed. Even your answers seem to not have been fully read.

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

Sioban Krzywicki One Orange Chip Points: 27770 More actions · Answer 15

CirquedeSQLeil (9/7/2010)
LutzM (9/7/2010)
jcrawf02 (9/7/2010)
LutzM (9/7/2010)
jcrawf02 (9/7/2010)
Do you suppose 5 minutes to return one row of data will be too much for end users? 😛
Now I just have to figure out what the hell I did to that query...
If you're working for a government project: not at all. You might even need to add a WAITFOR clause... :-D;-)
It is essential to allow government staff to prepare themselves for the answer to the question they carefully typed into the PC over the last couple of days.... 😀
Am I using it right? WAITFOR 'Friday at 5pm'
Wait a minute! If you're talking about government staff you'll most probably be safe with WAITFOR 'Friday at 1pm'
Or do you have a 2nd shift in your Gvmt facilities? We don't.
When speaking of the gov, wouldn't it be more appropriate to say something like:
WAITFOR 'Anytime - we're not working anyway'😛

Wow. Just goes to show anyone can forget to check for wayward apostrophes. : -)

--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams