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

Creating Objects in C# From Stored Procedures Using Generics(techandit.com)

submitted by bryh(15) 3 years, 2 months ago

How to use Generics in C# to allow you to return an array of data objects directly from a stored procedure class read more...

add a comment |category: C# |Views: 38

tags: Generics StoredProcedure C# SQL another

Whats up with Stored Procedures these days?(spoiledtechie.com)

submitted by cheetahtech(815) 3 years, 7 months ago

When life throws you hard balls, you can either step back and take a swing or bunt the hell out of it. I just recently went to an information session on T-SQL, Stored Procedures and now LINQ. These folks discussed stored procedures and why they are so important in the world today. read more...

2 comments |category: Database |Views: 510

tags: Database storedproc spoiledtechie StoredProcedure SQL another

Sending SMTP Mail using a Stored Procedure(sqlteam.com)

submitted by markvu(10) 3 years, 10 months ago

Help me send SMTP mail using a stored Procedure that is auto send email read more...

add a comment |category: ASP.NET |Views: 96

tags: SMTP StoredProcedure Database ASP.NET another

SubSonic - Stored Procedure Tutorial(scribesonic.com)

submitted by monty(2575) 4 years, 6 months ago

Subsonic makes working with stored procedures and your database simple. Today we'll discuss the basics in getting SubSonic to allow you to very easily interface with stored procedures and your data store. read more...

add a comment |category: Community |Views: 2375

tags: StoredProcedure ScribeSonic KevinFricovsky Community ORM another

SQL Server: How to run a stored procedure at SQL Server start-up (weblogs.sqlteam.com)

submitted by spirit1(3160) 4 years, 9 months ago

This is acctually quite simple. There is 'startup' option that you can set to the procedure. Code included. read more...

add a comment |category: Database |Views: 17

tags: startup StoredProcedure SQLServer 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

How to retrieve stored procedure return values from TableAdapter(blogs.msdn.com)

submitted by dalziel(6230) 5 years, 9 months ago

If youve been wondering why you are not able to access stored procedure return values from TableAdapter, heres the solution for you. read more...

add a comment |category: ADO.NET |Views: 131

tags: StoredProcedure TableAdapter ADO.NET another