The one other thing that you can do with very large tables is to place them on a separate filegroup and backup the filegroup as a separate backup file. ...

I also realized that since the proc has been compiled with ANSI_NULL set to ON it should always be running under the ANSI_NULLS ON. I ran the proc from...

I also realized that since the proc has been compiled with ANSI_NULL set to ON it should always be running under the ANSI_NULLS ON. I ran the proc from...

I shall try and do this. My only confusion then is how the Internet app by itself behaves like ANSI_NULLS are set to ON. What I mean is...

Actually found that the problem was because I was compiling the proc with ANSI_NULLS OFF, the minute I changed it back to ON the recompiling stopped once the plan was...

Fantastic article Brian.

I noticed with a proc that I'm running, that it recompiles the proc based on the parameters that are being passed to it. So if you run...