Sproc Executing Slow? It Might be This (ferventcoder.com)
submitted by
ferventcoder(780) 3 months, 3 days ago
So you have stored procedure and it’s having issues. When you run it, it returns really fast. When .NET runs it, its like a dog.
The first thing you learn about SQL Server is that it has something called ARITHABORT and it is turned on in SQL Management Studio and OFF in ADO.NET. Yeah you heard that right. OFF. So when you find this out, your first thought is WTF, mate?! Why do we have to make this hard on ourselves?
|
category: Database
|
Views: 6
tags:
StoredProcedure sproc Database SQL another
Everyones tags:
Your Tags: