Stored procedures DONOT increase performance(.NET and SQL training
When asked in .NET interviews compare Stored procedure VS Inline query the first thing that people answer is Stored procedures increase performance.In this video we will try to clear this misunderstanding that stored procedure increase performance. From SQL server 2005 onwards any SQL which comes to SQL server will be cached. So the performance using stored procedure or in-line queries are both same.
Your Facebook Friends on WizIQ