storedprocedures

Dealing with nested stored procedures can be tricky on transaction. This article will show you how to avoid common mistakes.

When a lock occurs you can tell the compiler how long it should wait before giving up. Here's how to use this setting

When developing custom SQL it's important that your code does not block the main application. This article explains how you can use deadlock priority to control this.

In this article I will try to explain schemas and how they can help you organise your code. I will also give you some examples of how I use them in my applications.

When writing code that fetches data your could either use SQL queries in your code, or you could call a stored procedure to fetch data. Here's a couple of reasons for why a stored procedure in many cases is the better option.