|The Message text:
This email was created by [your name] who thought you would be interested in the following Article:
"SQL Server: A Query Slow in SSMS, Fast in Application, WHY?"
Today, a colleague asked me, why his simple selectquery is taking around 3000ms (3 Seconds) to execute while, same query is quite fast when executed from application. Answer is simple: SQL Server Management Studio use RBAR-Row By Agonizing Rowmethod to fetch rows and inform row by row to SQL Server
CodeProject also contains hundreds of articles, free source code samples and applications to help in your day to day programming. Why not give it a try!