I think you would have to look into the idea of build streams. I'm not certain that this is what they are doing but that is my guess. So, the...

I have always found it to be more consistent if I specify the default mail profile name which is "MS Exchange Settings" unless you did it differently.

So, I would...

I have to say, I love the out-takes. Sorry, but I do laugh. 🙂

As to the non-competes, they are clearly necessary with some positions or there would be some serious...

Ok, looks like I was too late...

Good to remember to put it back to the default profile after you complete your task though.

Wondering if you were to set up another profile in Outlook then within the script do the following;

xp_stopmail

go

xp_startmail 'Non Default Profile' --This is the name for the non-default profile

go

--Do...

Wayne,

Did the trace catch the application name? My guess is that it is embedded somewhere in some app / process.

Nice! More stuff to look at in my tuning efforts now. Thanks for the help and I will review your blog post for more details!

I have found that the last suggestion that Gail put forward with the use of subprocs works pretty well. Makes for a bit more work drilling down to the final...

So, how can you determine if there is a partial scan when the plan is showing an index seek? Will that show up when using set showplan_full on? Curious. Thanks.

Try running the whole script (copy out of the stored proc) with the "set statistics time on" statement prior to the first line of the code. My guess is that...

Do you want the data that is updated on the server2 table to replicate back to the server1 table? If so, then you could create the transactional publication to allow...

Yeah, and as Gail replied earlier, the backups of the whole server are not backups as the database has to be in a state where there is no activity to...

...deny select on all the tables and watch for errors in the application? 😀 Ok, bad advice.

Seriously, you might want to try to trace this but if there is...

Yes, you can delete it from Management Studio (EM) but the file has to be empty first so, if you right click on the database go to tasks > shrink...

....oops, didn't read your post very well. My guess is you are maxed out with memory on the box. 🙂 Still sounds like there may be some VAS pressure and...