Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 36,001 through 36,015 (of 66,712 total)

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

TomThomson SSC Guru Points: 104773 More actions · Answer 1

Jeff Moden (5/10/2012)
Koen Verbeeck (5/9/2012)
GilaMonster (5/9/2012)
Koen Verbeeck (5/9/2012)
Is this an Oracle thing?
No, don't touch that myself.
Normally I don't either, but someone has to convert all that PL/SQL to T-SQL...
Neh... get the specs and rewrite it. It'll be easier.

Is it perhaps a bit optimistic to assume that a shop that uses Oracle can spare the effort to keep the specs up to date over the years?

Tom

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

L' Eomot Inversé (5/10/2012)
Jeff Moden (5/10/2012)
Koen Verbeeck (5/9/2012)
GilaMonster (5/9/2012)
Koen Verbeeck (5/9/2012)
Is this an Oracle thing?
No, don't touch that myself.
Normally I don't either, but someone has to convert all that PL/SQL to T-SQL...
Neh... get the specs and rewrite it. It'll be easier.
Is it perhaps a bit optimistic to assume that a shop that uses Oracle can spare the effort to keep the specs up to date over the years?

It is 🙂

Already found 4 errors in the specs this morning. It's going to be a long month 😀

edit: but we're migrating Oracle servers to SQL Servers, so it's all worth in the end 😀

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

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

Wow. I come back to The Thread and find the lot of you talking blasphemy.

I think I shall strap myself to the porkchop launcher and launch myself out of reach of such horrible discussions.

I mean, really, Oracle? What horrible thing has infected this place?

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.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 4

Brandie Tarvin (5/10/2012)
I mean, really, Oracle? What horrible thing has infected this place?

I'm working as fast as I can to get rid of it 🙂

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

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

Koen Verbeeck (5/9/2012)
GilaMonster (5/9/2012)
Your doing it wrong....
...
Why use one update where 4 will do?
Is this an Oracle thing? I've seen this a lot lately in Oracle code.
(and unfortunately, also in SSIS packages with OLE DB commands :crazy:)

Funny thing, the year I was working with Oracle, I found myself writing in t-sql first, then converting it to PL-SQL. Helped me to avoid writing cursors to accomplish the work. Oh, I lied a bit. I did have to write cursors where I needed to return result sets from stored procedures. Had to return reference cursors to the calling application. At least I didn't write any for doing real work.

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

Jeff Moden (5/10/2012)
Lynn Pettis (5/9/2012)
Jeff Moden (5/9/2012)
Lynn Pettis (5/9/2012)
Sorry for the code, but I need a place to keep these solutions for a hypothetical problem on another thread.
Wow! Working with Oracle really did put the pinch on you. 😀
Actually, it is he-who-is-without-clues that put the pinch on me. :w00t:
Trying a different tact to see if we can get him to finally give us what we need to help him.
I've found that when someone can shake off multiple vollies of high velocity, point blank range originated and numbered porkchops aimed squarely at the soft parts of the calcium knob, it's time to move on. You might actually hurt the guy. 😉

Well, you all know me, as much as I want to give up, I feel like I have to try again.

Unfortunately looks like others are starting to pile on over on that thread.

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

Brandie Tarvin (5/10/2012)
Wow. I come back to The Thread and find the lot of you talking blasphemy.
I think I shall strap myself to the porkchop launcher and launch myself out of reach of such horrible discussions.
I mean, really, Oracle? What horrible thing has infected this place?

Let's team up Oracle with nHibernate! That was what we were using on the project I was working on at Honeywell.

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

Lynn Pettis (5/10/2012)
Brandie Tarvin (5/10/2012)
Wow. I come back to The Thread and find the lot of you talking blasphemy.
I think I shall strap myself to the porkchop launcher and launch myself out of reach of such horrible discussions.
I mean, really, Oracle? What horrible thing has infected this place?
Let's team up Oracle with nHibernate! That was what we were using on the project I was working on at Honeywell.

Don't make me disown you and disavow all knowledge of this forum, Lynn. It could get ugly if I have to do that...

@=)

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 9

Lynn Pettis (5/10/2012)
Well, you all know me, as much as I want to give up, I feel like I have to try again.
Unfortunately looks like others are starting to pile on over on that thread.

Yep. I tried to be useful, but without any response from the OP and the piling on, it's about time to abandon that thread.

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

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

Koen Verbeeck (5/10/2012)
L' Eomot Inversé (5/10/2012)
Jeff Moden (5/10/2012)
Koen Verbeeck (5/9/2012)
GilaMonster (5/9/2012)
Koen Verbeeck (5/9/2012)
Is this an Oracle thing?
No, don't touch that myself.
Normally I don't either, but someone has to convert all that PL/SQL to T-SQL...
Neh... get the specs and rewrite it. It'll be easier.
Is it perhaps a bit optimistic to assume that a shop that uses Oracle can spare the effort to keep the specs up to date over the years?
It is 🙂
Already found 4 errors in the specs this morning. It's going to be a long month 😀
edit: but we're migrating Oracle servers to SQL Servers, so it's all worth in the end 😀

We're moving a bunch of Oracle to SQL Server here too, I'm happy that we're doing it, but interacting with Oracle is a pain.

One really annoying bit is the connection. The SSIS package just doesn't want to run as a job, wacky permissions errors. At least the Attunity source tool works well.

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

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

Thanks guys and gals. I removed the cursor code from my post. I moved it over to that other thread in hopes that he-who-is-without-clues may see it.

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

WayneS (5/10/2012)
Lynn Pettis (5/10/2012)
Well, you all know me, as much as I want to give up, I feel like I have to try again.
Unfortunately looks like others are starting to pile on over on that thread.
Yep. I tried to be useful, but without any response from the OP and the piling on, it's about time to abandon that thread.

Thank you Wayne. I posted my code on the thread as well. I wanted to wait and see his response first, but thiught I should just post it now.

WayneS SSC Guru Points: 95460 More actions · Answer 13

Hey Threadizens,

Regarding today's (10 May 2012) QOTD: several folks have stated that it could have been worded better. My question to you is how would you have worded it better? Post your ideas with the QotD discussion (not The Thread!), or PM me if you desire.

Personally, I thought that the question clearly states what is needed, and that there is only one possible correct answer. Though the answers do require you to know what is going on.

I view the QotD has having two purposes:

1. quiz on what you know

2. learn

So phase 2 of my learning is: how could I have done it better?

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

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

WayneS (5/10/2012)
Hey Threadizens,
Regarding today's (10 May 2012) QOTD: several folks have stated that it could have been worded better. My question to you is how would you have worded it better? Post your ideas with the QotD discussion (not The Thread!), or PM me if you desire.
Personally, I thought that the question clearly states what is needed, and that there is only one possible correct answer. Though the answers do require you to know what is going on.
I view the QotD has having two purposes:
1. quiz on what you know
2. learn
So phase 2 of my learning is: how could I have done it better?

Wayne it took me a couple of times to understand the question but I can't think of another way to ask it. It is a very specific question and imho the wording was as clear as it could be.

I thought it was a good question on a topic I know next to nothing about. I certainly learned something from it.

_______________________________________________________________

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/

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

Clearly it's

WAYNES'S WORLD, PARTY TIME, EXCELLENT

QOD (http://www.sqlservercentral.com/questions/T-SQL/89819/) and article (http://www.sqlservercentral.com/articles/Performance/89505/) published today.