sqlserver

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

Ever wondered how a simple index could cripple your application? Dive in to uncover the hidden pitfalls of over-indexing and discover ways to keep your system running smoothly.

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

Discover how to troubleshoot and fix database locks in SQL Server. Read on to save time and money!

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.

Curious about safeguarding your SSRS Reports? Dive in to explore why readonly access is not just a choice, but a necessity!

Intrigued by the idea of optimizing your database performance and security? Want to learn how to set up a separate reporting database without a hitch? Click to read more and discover how you can take your data strategy to the next level.

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.