tiberius icon indicating copy to clipboard operation
tiberius copied to clipboard

Published 20 hours ago • verified publisher icon steffengy

Prefer sp_executesql over sp_prepare

Open peschkaj opened this issue 6 years ago • 1 comments

sp_prepare suffers from some poor optimization issues in SQL Server. Modern apps should be using sp_execute.

peschkaj avatar Oct 20 '18 01:10 peschkaj

Might have needed a reference to advocate this. Here's the issue being addressed by Microsoft.

brokenthorn avatar Oct 20 '18 11:10 brokenthorn