Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 46,936 through 46,950 (of 66,712 total)

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

... Mark one off, 44 days on the calendar to go. 44 days on the calendar to go, 44 days to go, ...

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 2

Steve Jones - SSC Editor (1/14/2015)
Grant Fritchey (1/14/2015)
Back on topic for a moment.
Maybe I'm in a weird head-space at the moment, but it seems like the questions have gotten... not worse, but weirder. Sort of off the wall, no?
Meaning my QotDs?

No, I mean the forum questions. Jeez, I'm the paranoid one, not you.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 3

Grant Fritchey (1/14/2015)
Steve Jones - SSC Editor (1/14/2015)
Grant Fritchey (1/14/2015)
Back on topic for a moment.
Maybe I'm in a weird head-space at the moment, but it seems like the questions have gotten... not worse, but weirder. Sort of off the wall, no?
Meaning my QotDs?
No, I mean the forum questions. Jeez, I'm the paranoid one, not you.

The Illuminati must have taken over and start posting questions.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

spaghettidba SSC Guru Points: 105732 More actions · Answer 4

Catching up after a few days away...

@steve-2:

I would buy the X5. BMWs are great cars and even old ones (mine is 6 year old) look like new. The engine is virtually everlasting, the chassis is extremely good and allows great handling. No vibrations in the dashboard (this one drives me crazy: n.1 reason for me to change car!) and good materials overall.

Lexus makes solid quality cars, but they tend to age worse than german cars. I think they use slightly inferior materials, but I could be wrong. The engines are great as well.

@Koen:

Huge congrats man! You deserve it!

@Brandie:

I'm planning to go to PASS too. Good luck with your boss! BTW, does anybody know the dates for PASS 2015?

-- Gianluca Sartori

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

Koen Verbeeck (1/13/2015)
FYI, I received the Author of the Year award at MSSQLTips.com!
Thanks everyone for voting!

Very well done mate, richly deserved.

^{“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 6

Lynn Pettis (1/14/2015)
Steve Jones - SSC Editor (1/14/2015)
Boy, it seems like my questions are getting worse lately. Taking a beating in the QoD.
Don't worry about it. Some people just have to nitpick everything.

Too many folks view QoD as a points-acquisition opportunity as opposed to the learning opportunity that it is, and whine at the most obscure ambiguities. Anyway, there are more nuggets to be found in the discussion of a disputed QoD than one that isn't.

^{“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

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

Grant Fritchey (1/14/2015)
Maybe I'm in a weird head-space at the moment, but it seems like the questions have gotten... not worse, but weirder. Sort of off the wall, no?

I'm with you. There have been several the last few days that I've opened the thread, read the question, closed the browser window.

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

BrainDonor SSCoach Points: 19254 More actions · Answer 8

I'm planning to go to PASS too. Good luck with your boss! BTW, does anybody know the dates for PASS 2015?

http://www.sqlpass.org/summit/2015/RegisterNow.aspx

Steve Hall
Linkedin
Blog Site

spaghettidba SSC Guru Points: 105732 More actions · Answer 9

BrainDonor (1/15/2015)
I'm planning to go to PASS too. Good luck with your boss! BTW, does anybody know the dates for PASS 2015?
http://www.sqlpass.org/summit/2015/RegisterNow.aspx

Thanks. I should have checked before asking 🙂

-- Gianluca Sartori

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 10

Luis Cazares (1/14/2015)
Brandie Tarvin (1/14/2015)
Koen Verbeeck (1/14/2015)
Luis Cazares (1/14/2015)
Congratulations Koen! When I grow up I want to be like you. :hehe:
Action figures will soon be available! 😎
With or without superhero capes?
Edna Mode
No capes!
...
Do you remember Thunderhead? Tall, storm powers? Nice man, good with kids.
...
November 15th of '58! All was well, another day saved, when... his cape snagged on a missile fin!
...
Stratogale! April 23rd, '57! Cape caught in a jet turbine!
...
Metaman, express elevator! Dynaguy, snagged on takeoff! Splashdown, sucked into a vortex!
...
No capes!

And yet it was a cape that saved the day (and Jack-Jack). @=)

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.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 11

ChrisM@Work (1/15/2015)
Lynn Pettis (1/14/2015)
Steve Jones - SSC Editor (1/14/2015)
Boy, it seems like my questions are getting worse lately. Taking a beating in the QoD.
Don't worry about it. Some people just have to nitpick everything.
Too many folks view QoD as a points-acquisition opportunity as opposed to the learning opportunity that it is, and whine at the most obscure ambiguities. Anyway, there are more nuggets to be found in the discussion of a disputed QoD than one that isn't.

Agreed. There are those that whine about everything they don't understand as well as a way of making excuses for getting something wrong. Well, when you can admit you don't know something to yourself, that's when you're open to learning something new. If you have to make a bunch of excuses and blame others for getting something wrong, you won't learn anything.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Steve Jones - SSC Editor SSC Guru Points: 736280 More actions · Answer 12

spaghettidba (1/15/2015)
Catching up after a few days away...
@steve-2:
I would buy the X5. BMWs are great cars and even old ones (mine is 6 year old) look like new. The engine is virtually everlasting, the chassis is extremely good and allows great handling. No vibrations in the dashboard (this one drives me crazy: n.1 reason for me to change car!) and good materials overall.
Lexus makes solid quality cars, but they tend to age worse than german cars. I think they use slightly inferior materials, but I could be wrong. The engines are great as well.

No worries, and I'd tend to agree with you after having a few German cars. However I drove a '99 Lexus with 324k miles on it. That was impressive. It drove well and the interior/exterior looked really good.

I need to drive a few more, but the X5 and RX350 are high on my list

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

I am having a discussion with somebody who swears that using

EXISTS(select 1

is way faster than just select *. I know Gail has an article on her blog but I can't find it (a search feature on there would be so helpful). Anybody know where such an article disproving that myth can be found? My google-fu is being elusive today.

_______________________________________________________________

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/

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 14

Sean Lange (1/15/2015)
I am having a discussion with somebody who swears that using
EXISTS(select 1
is way faster than just select *. I know Gail has an article on her blog but I can't find it (a search feature on there would be so helpful). Anybody know where such an article disproving that myth can be found? My google-fu is being elusive today.

I can't find Gail's blog, but I did find Pinal Dave's blog[/url].

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.

Luis Cazares SSC Guru Points: 183706 More actions · Answer 15

Brandie Tarvin (1/15/2015)
Sean Lange (1/15/2015)
I am having a discussion with somebody who swears that using
EXISTS(select 1
is way faster than just select *. I know Gail has an article on her blog but I can't find it (a search feature on there would be so helpful). Anybody know where such an article disproving that myth can be found? My google-fu is being elusive today.
I can't find Gail's blog, but I did find Pinal Dave's blog[/url].

From Gail's blog I only found this: To TOP or not to TOP an EXISTS[/url],which has a link to the following blog post: The Age-Old SELECT * vs. SELECT 1 Debate

There's also a post from SQLSkills.[/url]

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2