Top 10 SQL Server Integration Services Best Practices

Question

Top 10 SQL Server Integration Services Best Practices

odanwada

SSCrazy

Points: 2133
More actions
September 12, 2010 at 4:55 am

#227645

Comments posted to this topic are about the item Top 10 SQL Server Integration Services Best Practices

Viewing 15 posts - 1 through 15 (of 26 total)

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

Jeff Moden SSC Guru Points: 1004323 More actions · Answer 1

I strongly suspect that 4.5 million sales transactions per second requires a fair bit of pretty expensive hardware and a whole lot of parallelism. I'm pretty sure that most installations can't do 4.5 million sales transactions per minute. 😉

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

Trevor R Udden SSC Journeyman Points: 78 More actions · Answer 2

Odanwada -

Did I miss a major citiation at the end of your article? You might want to try not blantly plagirizing others work. The article you claim as yours was originally written by Thomas Kejser and Denny Lee, members of the SQL Customer Advisory Team, and published in 2008.

Here is a link to the original article, and a wiki link to plagiarism, in case you are un familiar with its meaning.

http://sqlcat.com/top10lists/archive/2008/10/01/top-10-sql-server-integration-services-best-practices.aspx

http://en.wikipedia.org/wiki/Plagiarism

ekoner Mr or Mrs. 500 Points: 551 More actions · Answer 3

Trevor R Udden (9/13/2010)
Odanwada -
Did I miss a major citiation at the end of your article? You might want to try not blantly plagirizing others work. The article you claim as yours was originally written by Thomas Kejser and Denny Lee, members of the SQL Customer Advisory Team, and published in 2008.
Here is a link to the original article, and a wiki link to plagiarism, in case you are un familiar with its meaning.
http://sqlcat.com/top10lists/archive/2008/10/01/top-10-sql-server-integration-services-best-practices.aspx
http://en.wikipedia.org/wiki/Plagiarism

Well spotted Trevor. Had major deja vu reading the article this morning.

Measure twice, cut once

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

I was going to write a post stating that it was a great article, nicely written and really helpful for my daily routines. But luckily I've read the comments first.

Now I'll post a comment stating that the article is an excellent copy paste of another great article (which I didn't read yet).

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

r5d4 SSCrazy Points: 2522 More actions · Answer 5

The article has served to remind me to re-read the original.

I do hope Omeswar is not going to get paid for his Copy and Paste technique.

Jeff Moden SSC Guru Points: 1004323 More actions · Answer 6

Trevor R Udden (9/13/2010)
Odanwada -
Did I miss a major citiation at the end of your article? You might want to try not blantly plagirizing others work. The article you claim as yours was originally written by Thomas Kejser and Denny Lee, members of the SQL Customer Advisory Team, and published in 2008.
Here is a link to the original article, and a wiki link to plagiarism, in case you are un familiar with its meaning.
http://sqlcat.com/top10lists/archive/2008/10/01/top-10-sql-server-integration-services-best-practices.aspx
http://en.wikipedia.org/wiki/Plagiarism

I don't know if anyone else has done it but thanks for pointing out the plagiarism and I've reported it to the folks at SSC.

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

steveb. SSC-Forever Points: 46733 More actions · Answer 7

steveb.

SSC-Forever

Points: 46733

September 13, 2010 at 6:29 am

#1219984

I thought this article seemed very familiar..

marklegosz SSCrazy Points: 2816 More actions · Answer 8

And they use to say immitation was the greatest form of flattery... Turns out plagiarism is the new immitation.

Congrats Thomas Kejser & Denny Lee on a great article!

SanjayAttray SSChampion Points: 13157 More actions · Answer 9

Nice article. But, for Omeshwar, Nice hard work of CTRL + A, CTRL + C and CTRL + V.

Nothing wrong in taking knowledge / Points from others, but there should be some changes when claiming it as your own.

SQL DBA.

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 10

stevefromOZ

SSC-Forever

Points: 43646

September 13, 2010 at 8:06 am

#1220059

can i take back my article rating somehow?

Steve.

SanjayAttray SSChampion Points: 13157 More actions · Answer 11

stevefromOZ (9/13/2010)
can i take back my article rating somehow?

Steve, it's a pure form of plagiarism. But, why take the rating out for article. It's a well written article. Perfect reading to start Monday morning.

SQL DBA.

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

My apologies for the plagiarism. I have removed the article, and reported the author to OSI Consulting[/url], the employer whose email server was used to send the article in.

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 13

@sanjay - The problem is not so much the rating as the attribution of the rating to someone who didn't do the work.

Steve.

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 14

SanjayAttray (9/13/2010)
stevefromOZ (9/13/2010)
can i take back my article rating somehow?
Steve, it's a pure form of plagiarism. But, why take the rating out for article. It's a well written article. Perfect reading to start Monday morning.

We cannot republish something that is plagiarized. It doesn't matter how well written it is, it cannot be repeated here.