Environment versions
Network:
Windows 2003 Server
>Hi Viv,
>
>> And the CLR processing will require the same number of CPU cycles whether on the client or server so any time saved will be based on the size of the result set sent to the client.
>
>Server side processes aren't necessarily a matter of performance, but also of security. It's much easier to protect code loaded into a SQL server than it is to protect code that is distributed to all clients, especially if the code implements business secrets. A laptop with code is easier to steal than a SQL server in a secure server room. Whether such code has to run inside a SQL server,is a different matter, though...
True. I believe the link I posted discussed this. An example was using CLR to bake validation rules that couldn't be expressed in T-SQL into the database.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only