Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

New T-SQL Features in SQL Server 2005 Part 1 Expand / Collapse
Author
Message
Posted Wednesday, November 29, 2006 9:43 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:11 PM
Points: 35,546, Visits: 32,141

NOW I remember why I never looked at BOL 2005 ... Microsoft pushes the .NET stuff down your throat even on simple documentation...  BOL 2005 wants me to install the .NET Framework just to install it...

I cannot confirm nor deny the plagerism... with that in mind, I hate to cast a doubt, but that would explain the kinds of typos (words run together and 231 instead of 231) in the document... gosh, I sure hope Sushila was right about this one and that it's a "compilation" and not a plagerism.



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

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #326603
Posted Thursday, November 30, 2006 3:25 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, November 23, 2010 2:55 AM
Points: 142, Visits: 37

Thanks all for the comments on the article.I do agree there has been a bit of typing errors ,but I would be more careful next time.

The whole idea of writing this article came to me, as I realise there are many SQL Developers who are still working with SQL 2000 and dying to get hands on SQL 2005.I wrote this article specifically for them because Transact SQL is the easiest for any SQL developer to relate himself to.

I dont think referring MSDN can be termed as Plagiarism,after all we are using Microsoft product and there cant be anything more authentic.




Kindest Regards,

Sureshkumar Ramakrishnan

Post #326634
Posted Thursday, November 30, 2006 4:10 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, March 27, 2009 4:01 AM
Points: 14, Visits: 40

It's not 'referring', you've cut and paste 90% of the text from BOL. Without even providing a reference.

If you copy random chunks of your article and put the whole phrase in Google, result number 1 is MSDN with an article with the same name as your section heading and the exact phrase in the MSDN article.

e.g. "Common table expression (CTE) can be thought of as a temporary result", "A recursive CTE is one in which an initial CTE", "following example first creates a synonym for the base object"

The exact word-for-word phrases are returned on MSDN. If you use word-for-word without putting it in quotes and providing where the original is located it is plagiarism, you would be thrown out of a University, fired from a Newspaper, never be able to work in the field again. To do it not once but as an entire 'article' is extreme.

And you've still not provided the references you used:

New features SQL2005: http://msdn2.microsoft.com/en-us/library/ms170363.aspx

New TSQL Features: http://msdn2.microsoft.com/en-us/library/ms177591.aspx

Post #326642
Posted Thursday, November 30, 2006 4:16 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, November 23, 2010 2:55 AM
Points: 142, Visits: 37

If you read the article properly

The article clearly states the below

For further reference on CTE read the link: http://msdn2.microsoft.com/en-gb/library/ms190766.aspx.

If you are expecting us to know the features of SQL 2005 without refering to MSDN.I think you are wrong




Kindest Regards,

Sureshkumar Ramakrishnan

Post #326643
Posted Thursday, November 30, 2006 8:13 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 1:20 PM
Points: 1,276, Visits: 1,135

Here's what BOL says about CTE's (not at either link you posted, but rather here: http://msdn2.microsoft.com/en-us/library/ms175972.aspx)

"Specifies a temporary named result set, known as a common table expression (CTE). This is derived from a simple query and defined within the execution scope of a single SELECT, INSERT, UPDATE, or DELETE statement. This clause can also be used in a CREATE VIEW statement as part of its defining SELECT statement. A common table expression can include references to itself. This is referred to as a recursive common table expression."

Here's what the author said (http://www.sqlservercentral.com/columnists/sramakrishnan/2734.asp):

"Common Table Expressions : Common table expression (CTE) can be thought of as a temporary result set that is defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement. Unlike a derived query that was commonly used in SQL 2000, you dont need to copy the query definition multiple times each time it is used. You can also use local variables within a CTE definitionsomething you cant do in a view definition."

Basically the sentence fragment "defined within the execution scope of a single SELECT, INSERT, UPDATE, [or] DELETE" looks to be the same on this one. The reference the author posted to BOL at http://msdn2.microsoft.com/en-gb/library/ms190766.aspx has this to say:

"A common table expression (CTE) can be thought of as a temporary result set that is defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement. A CTE is similar to a derived table in that it is not stored as an object and lasts only for the duration of the query. Unlike a derived table, a CTE can be self-referencing and can be referenced multiple times in the same query."

Looks like a chunk of text was lifted word-for-word from BOL in this instance.  I'm not going to personally compare the whole article to BOL, but the author should have definitely used parenthetical and in-text citations, or footnotes, so that readers could tell exactly what was being quoted from BOL versus his original work.

To the author, here's what it might look like with a proper citation:

Common Table Expressions : Books Online provides this definition of a Common Table Expression: "Common table expression (CTE) can be thought of as a temporary result set that is defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement." (http://msdn2.microsoft.com/en-gb/library/ms190766.aspx). Unlike a derived query that was commonly used in SQL 2000, you dont need to copy the query definition multiple times each time it is used. You can also use local variables within a CTE definitionsomething you cant do in a view definition."

It's OK to quote from other sources, but you have to properly cite the sources.  Properly quoting and citing authoritative sources on a topic does not detract from your original work, but not properly citing sources makes all your work suspect.  Someone should write an article on that...

Post #326716
Posted Thursday, November 30, 2006 8:41 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, November 23, 2010 2:55 AM
Points: 142, Visits: 37

Thanks for the comments.I think this would definitely help me to better my articles in future.

In the next article I have concentrated more on providing the examples rather than describing the features in theory.Hope you guys would like it

Yeah One thing I admit of not having done is that I havent added all the references.This Iam definitely going to do in my future articles.

 




Kindest Regards,

Sureshkumar Ramakrishnan

Post #326726
Posted Thursday, November 30, 2006 8:44 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 1:20 PM
Points: 1,276, Visits: 1,135

No need to download it Just go to BOL on the msdn2 website: http://msdn2.microsoft.com/en-us/library/ms130214.aspx

 

Post #326731
Posted Thursday, November 30, 2006 1:52 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:11 PM
Points: 35,546, Visits: 32,141

Perfect, Mike... Thanks for the tip. 

And I see what everyone is talking about, especially you and Confucius247...   If you really want to get deeper, read the "Terms of Use" at the bottom of each page on the WebSite you just provided the link for... especially the part about "NOTICE SPECIFIC TO DOCUMENTS AVAILABLE ON THIS WEB SITE."  Authors might want to be a little bit more careful than they have...



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

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #326842
Posted Friday, December 1, 2006 7:42 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, January 11, 2013 12:30 PM
Points: 21, Visits: 344

I thought this was a great article, it sums up the key T-SQL additions. Just what we DBAs/developers need to know.  So what if parts are copied from BOL. Not all of us are need deep into 2005 yet to have 2005 BOL loaded and reference everyday. (Personally I do not like the new BOL, I guess I'm too used to 200 BOL).

Thanks

Dave

Post #326972
Posted Friday, December 1, 2006 10:34 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:11 PM
Points: 35,546, Visits: 32,141

I don't think the author intended it this way, but to answer your question of "So what if parts are copied from BOL"? Because...

1.  Plagerism is in pretty bad form.  Most learned readers would rather eat pond scum than read plagerized material.  By itself, copying material isn't plagerism... not giving very specific credit to the creators of the original infomation is.

2.  Because of the copy right Microsoft has on the info, the fact that the terms of use say "personal" and "non-commercial use" and may not be republished (in so many words), and the author got paid $50 for the web article which makes it both commercial and published, it's also against the federal copy right laws.

Some folks are worried about item 1 above... me too... I hate plagerism when it happens and represents one of the lowest forms of life there is.  Of more concern to me, though, is to warn my fellow authors that you can get the pant's sued off of you by Microsoft and other companies and, depending on the offense, may spend a little time in jail by doing this type of thing.  Ignorance is no excuse in the eyes of the courts.  Foreign nationals can also be expelled from the country within minutes of the conviction or jail time served.

Be careful what you copy, folks, even if you do give due credit...

Will Microsoft or other company come after you for this type of "minor" offense?  Dunno for sure but are you sure you want to test those waters?



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

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #327058
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse