SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Extended Procs


Extended Procs

Author
Message
sknox
sknox
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2604 Visits: 2832
Haven't had time to research SQL 2014 yet.
Guessed optimistically.
Got it wrong.

Can anyone explain why this should still be around when CLR has been available to replace its functionality since 2005?
Dana Medley
Dana Medley
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2494 Visits: 1696
Koen Verbeeck (9/30/2013)
Nice question. Never even heard about it, made me do some research.


+1 Good question. Never really used these, so it was good to do some research on it.



Everything is awesome!
Carlo Romagnano
Carlo Romagnano
SSCarpal Tunnel
SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)

Group: General Forum Members
Points: 4927 Visits: 3326
sknox (10/1/2013)
Haven't had time to research SQL 2014 yet.
Guessed optimistically.
Got it wrong.

Can anyone explain why this should still be around when CLR has been available to replace its functionality since 2005?

Because of performance! CLR is very dangerous: bad written code can waste cpu time and memory resource.

I run on tuttopodismo
pchirags
pchirags
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2351 Visits: 615
nice question Dave62..
sknox
sknox
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2604 Visits: 2832
Carlo Romagnano (10/1/2013)
sknox (10/1/2013)
Haven't had time to research SQL 2014 yet.
Guessed optimistically.
Got it wrong.

Can anyone explain why this should still be around when CLR has been available to replace its functionality since 2005?

Because of performance! CLR is very dangerous: bad written code can waste cpu time and memory resource.


And XPs can't!? Crazy
TomThomson
TomThomson
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14304 Visits: 12197
Dscheypie (10/1/2013)
MarkusB (10/1/2013)
Not sure about this question.
I think there is no correct answer given, because even the link provided for SQL 2014 says "Topic Status: Some information in this topic is pre-release and subject to change in future releases"

Since SQL 2014 is not released yet, you can't be sure what will be in it or not. So I would have chosen "None of the above"


No, Markus, Dave62 is right!
Look at this document:
http://msdn.microsoft.com/en-us/library/ms143729(v=sql.120).aspx

There also it is stated that this feature still exists and will be refused in future times. Just look for the key word "XP_API".

Or did I misunderstand you? You think that because it is pre-release it might change until the official release of SQL Server 2014? Then of course forget my remark above. I myself fought with this detail and decided to ignore it ;-)

Best regards

Jens-Peter :-)

Edit: detail etc.

Unless MS have radically changed their deprecation-removal policy, that fact that the Sql 2012 documentation lists the XP stuff (apart from 3 specific XPs) as available in the next release but to be removed some time in future", which can't be dismissed as pre-release, can be taken as definitive. I will be very surprised if they have adopted an "oh, we told them it wouldn't be withdrawn yet but we'll withdraw it now anyway even though there's not now time for them to change their stuff in time to adopt SQL 2014 any time reasonably soon" policy instead. If not because of the inevitable damage to revenue, then for the effect on how well their customers trust them.

Tom

SQLRNNR
SQLRNNR
SSC-Dedicated
SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)

Group: General Forum Members
Points: 32332 Visits: 18552
Stewart "Arturius" Campbell (10/1/2013)
I remember SQL 2008 & R2 and 2012 warning that this will be removed in a future version. It appears that 2014 still carries that warning.

I wonder if this will ever be removed...


I ponder the same thing.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

Toreador
Toreador
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2773 Visits: 8084
I guessed right, on the basis that very little deprecated functionality ever seems to get removed.
Someone will now post a massive list to prove me wrong :-D
Revenant
Revenant
SSCertifiable
SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)

Group: General Forum Members
Points: 7353 Visits: 4862
sknox (10/1/2013)
. . . Can anyone explain why this should still be around when CLR has been available to replace its functionality since 2005?

Deprecating this would necessitate massive changes to SharePoint.
TomThomson
TomThomson
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14304 Visits: 12197
Revenant (10/2/2013)
sknox (10/1/2013)
. . . Can anyone explain why this should still be around when CLR has been available to replace its functionality since 2005?

Deprecating this would necessitate massive changes to SharePoint.

Also, removing the ability to write extended SPs from customers while still supporting a very large and visible collection of XPs writen and released by MS would look a bit silly, and they still haven't managed to replace them all with something other than XPs (although they often don't use that prefix). But look, another 3 MS XPs (with SP prefex, of course) are withdrawn in SQL 2014, so they are gtting there (slowly).

Tom

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search