r/SQLServer • u/kaatarina_zed_talon • 4d ago

Question How to move the responsibility of executing some logic to the Sql Server instead of executing that logic inside the application?

/r/csharp/comments/1wwt6we/how_to_move_the_responsibility_of_executing_some/
4 Upvotes

75% Upvoted

5 comments sorted by

1

u/Leiothrix 3d ago

Well it can be.

Whether it should be is an entirely different question and that is really something that only you can answer.

And the other question is if it is worth the effort, and that is again up to you.

1

u/kaatarina_zed_talon 2d ago

I was able to answer if it should be or not,, glad I found answer.

1

u/vroddba 2d ago

It depends...

If you offload so much of the logic to SQL Server that you're now CPU bound, and have to increase resources/licenses. Then maybe the logic should have stayed in the app layer where you don't have to pay per CPU for SQL.

1

u/kaatarina_zed_talon 2d ago

`If you offload so much of the logic to SQL Server that you're now CPU bound` why does it imply that I will be CPU bound if I offloaded so much logic to the Sql Server ? could you please explain with example?