Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 52,906 through 52,920 (of 66,712 total)

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

Brandie Tarvin SSC Guru Points: 173061 More actions · Answer 1

GilaMonster (2/24/2016)
I disagree. Jupiter is descending.
http://what-if.xkcd.com/139/

That is an awesome link. Thanks, Gail.

On another note, this might be one of those days when I should step away from my computer. I get back from a week & 1/2 of vacation and the first thing I do is mix up three projects and try to do coding on one that should be done on another... Sigh. Jupiter is a nice distraction so I can reorder my thoughts and actually remember which project is doing what thing.

Good thing I made notes before I left. Bad thing I used shorthand, thinking I'd remember what the heck I meant.

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.

WayneS SSC Guru Points: 95460 More actions · Answer 2

jasona.work (2/24/2016)
SQLRNNR (2/24/2016)
GilaMonster (2/24/2016)
jasona.work (2/24/2016)
http://www.sqlservercentral.com/Forums/Topic1763775-3412-1.aspx
/Me leans back, grabs bucket of popcorn
Sure sounds like Gail answered the original question, yet for some reason the OP decided to focus on the comments about performance...
INSERT INTO UsersToBeIgnored...
Though, I might have to partition that table, it's running the current file out of space. 🙂
Then would you have multiple files in the partition? Would you span them across a gpt formatted volume? Should the volume be offset at 17.5k or something else?
What are the performance implications?
So what you are saying is the end result is that the partitioned table sucks for performance? 😉
What if we have 8 files per partition per database? Would that make performance better?
/Me hands Gail a wet fish, steps back out of the splatter zone...
:hehe:

Thanks... it's been too long since I've had such a good laugh.

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

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

Is it too early for these answers? http://www.sqlservercentral.com/Forums/Topic1764225-3411-1.aspx

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

Phil Parkin SSC Guru Points: 246960 More actions · Answer 4

Luis Cazares (2/25/2016)
Is it too early for these answers? http://www.sqlservercentral.com/Forums/Topic1764225-3411-1.aspx

Not at all.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Thomas Rushton SSC-Insane Points: 22649 More actions · Answer 5

Phil Parkin (2/25/2016)
Luis Cazares (2/25/2016)
Is it too early for these answers? http://www.sqlservercentral.com/Forums/Topic1764225-3411-1.aspx
Not at all.

At least you didn't go with LMGTFY, or JFGI...

Thomas Rushton
blog: https://thelonedba.wordpress.com

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

ThomasRushton (2/25/2016)
Phil Parkin (2/25/2016)
Luis Cazares (2/25/2016)
Is it too early for these answers? http://www.sqlservercentral.com/Forums/Topic1764225-3411-1.aspx
Not at all.
At least you didn't go with LMGTFY, or JFGI...

That would have implied additional work.

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

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

I am so glad I don't have any experience, yet, with replication so that I have no idea what SS is trying to do or why he isn't getting what he expects.

Brandie Tarvin SSC Guru Points: 173061 More actions · Answer 8

Lynn Pettis (2/25/2016)
I am so glad I don't have any experience, yet, with replication so that I have no idea what SS is trying to do or why he isn't getting what he expects.

Wow. He really didn't include any details on what he's trying to accomplish.

I've created stuff to deliberately fail before, but usually after I've done every other bit of troubleshooting I can think of.

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.

jasona.work SSC Guru Points: 50117 More actions · Answer 9

Man, my music tastes go all over the place...

Listening to my playlist on my phone today, just went from Dragonforce, now I'm listening to an Alex Band tune w/Santana, and the whole thing started off with Motley Crue...

Who knows, maybe Weird Al next...

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 10

Grant Fritchey (2/24/2016)
Jeff Moden (2/24/2016)
SQLRNNR (2/24/2016)
GilaMonster (2/24/2016)
SQLRNNR (2/24/2016)
GilaMonster (2/24/2016)
jasona.work (2/24/2016)
http://www.sqlservercentral.com/Forums/Topic1763775-3412-1.aspx
/Me leans back, grabs bucket of popcorn
Sure sounds like Gail answered the original question, yet for some reason the OP decided to focus on the comments about performance...
INSERT INTO UsersToBeIgnored...
Though, I might have to partition that table, it's running the current file out of space. 🙂
Then would you have multiple files in the partition? Would you span them across a gpt formatted volume? Should the volume be offset at 17.5k or something else?
What are the performance implications?
So what you are saying is the end result is that the partitioned table sucks for performance? 😉
What if we have 8 files per partition per database? Would that make performance better?
Depends on what time sunset is and which planets are ascending.
Jupiter Ascending
Earth Ascending inversely
Pork Chops Away!:-D
I get really tired of these moroffs blasting the likes of Gail when they don't actually have a clue. Hope he likes his own medicine. 😉
I swear we've had almost this exact conversation with identical jokes before.

Many times. That's because it's the same old story with some of these folks. Hopefully, my response on that thread got his attention.

--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)

djj SSCoach Points: 18831 More actions · Answer 11

jasona.work (2/25/2016)
Man, my music tastes go all over the place...
Listening to my playlist on my phone today, just went from Dragonforce, now I'm listening to an Alex Band tune w/Santana, and the whole thing started off with Motley Crue...
Who knows, maybe Weird Al next...

Went from "Jesus Is Risen Today" to "Layla" a little later Weird Al...

djj SSCoach Points: 18831 More actions · Answer 12

Spent a couple hours rewriting a query that was taking 4 hours. Got it down to 8 minutes! Then the light bulb goes off and I realize my code does not do what the other code did. :hehe: I have corrected the issue with a CROSS APPLY and am now getting the 66 million expected records (17 minutes), however still I need to insert them into the final table where I just changed the clustered key to be sensible. (6 minutes and counting)

Alan Burstein SSC Guru Points: 61141 More actions · Answer 13

djj (2/25/2016)
Spent a couple hours rewriting a query that was taking 4 hours. Got it down to 8 minutes! Then the light bulb goes off and I realize my code does not do what the other code did. :hehe:

+1000

Been there, done that... I hate when that happens! 😛

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

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

Alan.B (2/25/2016)
djj (2/25/2016)
Spent a couple hours rewriting a query that was taking 4 hours. Got it down to 8 minutes! Then the light bulb goes off and I realize my code does not do what the other code did. :hehe:
+1000
Been there, done that... I hate when that happens! 😛

Yeah, me too. But when you get it right and you watch the 3 hour query go down to 2 seconds, it sure is nice. Or even better, when you get 8-second query that gets run 30,000 times a day down to 50 ms.

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

Neil Burton SSC-Insane Points: 22999 More actions · Answer 15

djj (2/25/2016)
jasona.work (2/25/2016)
Man, my music tastes go all over the place...
Listening to my playlist on my phone today, just went from Dragonforce, now I'm listening to an Alex Band tune w/Santana, and the whole thing started off with Motley Crue...
Who knows, maybe Weird Al next...
Went from "Jesus Is Risen Today" to "Layla" a little later Weird Al...

I've gone from Cannibal Corpse to Pink Floyd while out running before. That can upset the rhythm a bit, particularly at the bottom of the climb to get home.

On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537