Object Grouping Best Practices: Using Schemas for Logical Separation

You've probably all noticed a change since SQL Server 2000 with respect to objects: formerly DB.ObjectOwner.Object ,

Querying the Procedural Cache on Canada Day (July 1st)

The goal of this post is to understand the procedure cache and execution plans to ensure we use fewer resources and that queries run better. Better means higher throughput, more concurrency and fewer resources – as described by MVP Joe Webb during SQLTeach in Vancouver just last month.

Object Grouping Best Practices: Using Schemas for Logical Separation

Originally written in French last year, now revised for you in my native language below:
You've probably all noticed a change...

Querying the Procedural Cache on Canada Day (July 1st)

The goal of this post is to understand the procedure cache and execution plans to ensure we use fewer resources...

How to Avoid Database Restore Issues by a Simple Script Edit - A DB Restore Work-around

During the process of applying changes to a production database - let's call it Change Management (pick your ITIL or COBIT...

Why You'll Want to Create Your Temp Tables Before Populating them

The point of this post is to cleary explain how the combination of the use of data definition language for your temporary...

TRY/CATCH - The Great Way to Handle Exceptions in SQL 2005/8

The goal of this post is to explain how to handle errors thanks to a useful T-SQL functionality, available since SQL 2005 onwards, that developers are already used to – and similar to how exceptions are handled in the Visual Studio environment.

TRY/CATCH - The Great Way to Handle Exceptions in SQL 2005/8

This is based on the original post in Franglais.

The goal of this post is to explain how to handle errors...

Configuring Auto-Retry on SQL Server Agent

The goal of this post is to explain how to take advantage of Auto-Retry and why you will want to use it. I hope to clarify in which circumstances an auto-retry works best and when not to use it also. The (disclaimer!) point is that every job has its own constraints, requirements, and has to be evaluated individually for whether an auto-retry will work. I will try and keep this summary short and crisp, but still with enough detail to understand auto retry best.

Configuring Auto-Retry on SQL Server Agent

The goal of this post is to explain how to take advantage of Auto-Retry and why you will want to...