Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 20,251 through 20,265 (of 66,738 total)

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

WayneS SSC Guru Points: 95460 More actions · Answer 1

jcrawf02 (10/12/2010)
Wayne, I think you're going to make Jack and Andy very happy with that comment. 🙂

.... wonder if I can be a presenter for my "Comparing Table Variables and Temporary Tables" article??? Jack/Andy - are you interested?

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

WayneS (10/12/2010)
jcrawf02 (10/12/2010)
Wayne, I think you're going to make Jack and Andy very happy with that comment. 🙂
.... wonder if I can be a presenter for my "Comparing Table Variables and Temporary Tables" article??? Jack/Andy - are you interested?

Wait for the SQLRally call for speakers to be announced and submit an abstract.

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

WayneS SSC Guru Points: 95460 More actions · Answer 3

GilaMonster (10/6/2010)
WayneS (10/6/2010)
GilaMonster (10/6/2010)
... I have 3 table variable myths targeted.
Did I cover them in my article[/url]? If not, I'd love to know what you have, so that I can enhance it (and add it to the presentation that I'm making on this article!).
Two yes, one no, though I'm planning to debunk one of the ones you did in a very different way.

Gail - EXCELLENT job on debunking those table variable myths. I see a couple of changes coming to my presentation when I start proving that some myths are wrong.

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

Jeff Moden SSC Guru Points: 1004407 More actions · Answer 4

jcrawf02 (10/12/2010)
Jeff Moden (10/12/2010)
WayneS (10/11/2010)
Jeff Moden (10/10/2010)
WayneS (10/10/2010)
Hey gang... not definite yet, but my wife is talking about letting me spend the $ to go to PASS. 😀
Any suggestions on good, inexpensive, close places to stay? Guys to share a room with? Are any discounts still available? It's looking like it's going to cost us about $3k... does that seem about right to you'll?
Do you snore? I actually don't want your opinion on that... ask your wife. Do you snore? 😉
She says yes - a little bit louder than heavy breathing.
Just remembered that I'm also scheduled to give my presentation to my UG on that Thursday....
No pun intended, but I'll have to pass then. I'm a super light sleeper. Yeah... it's been a problem all my life and was really tough in the service.
At the risk of encountering a porcine missile, have you ever heard of earplugs? 😀

Yes... first... can't wear those on submarines because of sudden pressure changes and they never seemed to do the trick for me anyway.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004407 More actions · Answer 5

Steve Jones - SSC Editor (10/12/2010)
jcrawf02 (10/12/2010)
At the risk of encountering a porcine missile, have you ever heard of earplugs? 😀
I have found that single rooms are the best earplugs 😛

Agreed. Besides, I've found that even a deboned pork chop won't fit in an ear. 😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

TomThomson SSC Guru Points: 104773 More actions · Answer 6

I just read all the new SQL Tuesday blog entries - first time I've done this. Wow! 😀 Pretty impressive, on the whole.

Tom

WayneS SSC Guru Points: 95460 More actions · Answer 7

Tom.Thomson (10/12/2010)
I just read all the new SQL Tuesday blog entries - first time I've done this. Wow! 😀 Pretty impressive, on the whole.

Hey, first time for me also (don't know if I got all of them, but read a good dozen). What was interesting (to me) is that a few covered the same myth.

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

WayneS (10/12/2010)
Tom.Thomson (10/12/2010)
I just read all the new SQL Tuesday blog entries - first time I've done this. Wow! 😀 Pretty impressive, on the whole.
Hey, first time for me also (don't know if I got all of them, but read a good dozen). What was interesting (to me) is that a few covered the same myth.

Funny how that happens - It's bound to happen though.

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

Steve Jones - SSC Editor SSC Guru Points: 736479 More actions · Answer 9

Wayne,

good to hear you're considering the Rally. Hopefully I'll be there as well. Working on pre-con submission right now.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

Anybody know the link to sponsor SQLSat 49 as a Blogger?

http://www.sqlservercentral.com/blogs/andy_warren/archive/2010/09/13/sql-bloggers-_1320_-build-your-brand-and-sponsor-sqlsaturday-_2300_49.aspx

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

Johan Bijnens SSC Guru Points: 135376 More actions · Answer 11

GilaMonster (10/12/2010)
The Dixie Flatline (10/12/2010)
Modest proposal for you, Gail: Take your katana and wakazashi to the next meeting.
Oh this wasn't a planned meeting. This was me getting hauled up in front of someone on the management team and shouted at. Next time I think I'll just be walking away, picking up my laptop and leaving.

In many cases, shouting is a sign of not understanding what the problem is.

In some companies that's the upmost exellent way for managers to put their stamp on their departments/projects.

At least that's what they think !

For those companies it ends up with staff suffering burnouts, not developing their skills to the companies advantage, being quietly in any corner of a room starting at 9 and waiting for 5.

For sure it isn't a pleasant working environment.

There are three ways to handle a rhino:

- play dead

- walk away quietly

- head first collision

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 12

Paul White NZ (10/12/2010)
WayneS (10/12/2010)
I think instead of clearing the fog, we've managed to make it denser. :w00t:
Ah I see that thread is fully doomed now - Chris Morris has arrived :w00t:

Derailment!!

My daughter's favourite word when she was 3 or something.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 13

GilaMonster (10/12/2010)
After a meeting this morning there are several things that I would love to rant about at length. However it might get ugly. Hence I will restrain myself to three things.
1) #$^&*%!@%^%$#*(&*^#@!@(%@&_^&$%^#$#@$#@#@!!!!!!!!!!!!!!!!!!!!!
2) Consultants are not there to be your scapegoats
3) Stabbing your team members in the back (figuratively) is not a good way of advancing your career. It doesn't take long for people to figure out what's happening and when they do they will hate you forever.

Sympathy in spades, Gail. In 19 years of contracting I've never come across it this bad. Nowhere near. Take heart from this - it's unlikely to be as bad ever again.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

TomThomson SSC Guru Points: 104773 More actions · Answer 14

WayneS (10/12/2010)
Tom.Thomson (10/12/2010)
I just read all the new SQL Tuesday blog entries - first time I've done this. Wow! 😀 Pretty impressive, on the whole.
Hey, first time for me also (don't know if I got all of them, but read a good dozen). What was interesting (to me) is that a few covered the same myth.

A good dozen? You didn't get them all. I think I read 24 or 25.

Tom

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 15

CirquedeSQLeil (10/12/2010)
Anybody know the link to sponsor SQLSat 49 as a Blogger?
http://www.sqlservercentral.com/blogs/andy_warren/archive/2010/09/13/sql-bloggers-_1320_-build-your-brand-and-sponsor-sqlsaturday-_2300_49.aspx

Sorry, Jason. Call for sponsors is closed.

However, on future SQL Saturday events, just click the sponsors page and you can register as one.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.