Sproc Executing Slow? It Might be This(ferventcoder.com)

submitted by ferventcoder(836) 2 years, 6 months 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? read more...

add a comment |category: Database |Views: 7

tags: StoredProcedure sproc Database SQL another

Quick search within ALL stored procedures ... (vadivel.blogspot.com)

submitted by vmvadivel(195) 5 years, 4 months ago

This article would explain in detail the methods involved in searching strings within ALL stored procedures. I am sure there might have been situation where you want to find out a stored procedure where you remember writing some complex logic. Won't it be nice if we can find out that stored procedure where we have already written that important piece of code .. so that we can reuse? If your answer is "yes" read on. read more...

add a comment |category: Database |Views: 14

tags: StoredProcedure sproc SQL search another