The truth about Dynamic SQL and Stored Procedures….

By patrickwellink
January 7, 2008
Comments Off on The truth about Dynamic SQL and Stored Procedures….

Well I am not going to say what’s better or what I prefer, but I can only give my view of things.

What everybody seems to forget is that an external person with very good understanding of SQL (commonly know as a DBA) can solve performance problems when stored procedures are used.
And I totally agree that Stored Procedures are overkill for most of the the simple CRUD functionality. So I am not going to start a debate about that.

But just one question for all those who are against stored procedures.

What if the generated dynamic SQL performs bad. If a SPROC was used a SQL DBA could have tuned the query.
And by tuning I don’t mean adding some indexes, but maybe cursor’s / memory tables / views / CLR etc. Just to get the results in the fastest possible way.

How would you do this with dynamic SQL ??

Comments: 0

Comments are closed.

  • Recent Posts
  • Recent Comments
  • Archives
  • Categories
  • Meta