Roy,

Send me an announcement and I'll run it.(sjones at sqlservercentral)

One thing that I think helps is for you to get to know people, know what they're good at, and...

I don't think either cache is cleared. The procedure cache, because that will likely be cleared as space is needed. Same for execution plans.

For the data cache, that's data, not...

I'd say that the answer to the editorial is "it depends".

I think that Brad has made good general observations that apply to most DBAs, especially successful ones. I feel that...

I'd suggest that you try shorter presentations. The Orlando and Denver groups will do a 30 minute "opening" for new presentations or speakers. Give them a chance to talk about...

I saw this in my notifications, thinking, great, another fun complaint for Monday.

And apparently you folks are getting ready for lunch. Enjoy!

are you talking the built in external stored procedures, or ones you've added?

Technically it creates the row, updates the identity, then removes it. The identity update is outside the scope of the transaction (in case other connections need the values), so it...

The question was for database snapshots, not snapshot replication, but I can see where the confusion would lie. I have never heard a replication snapshot called a "snapshot of xxx...

You may be right, and it is better to have more than less. Given the cost, it might make sense just to go with 8GB.

However I've had plenty of corporate...

I think you'll have to have the SAN team dig in. A SAN network error, disk error, any number of things could have caused it. I'd have ignored it, but...

I think 8GB might not be a min, 4, or even 2 could work. It depends on what load you'll experience. What are the database sizes you expect, the workload,...

That gateway supports email, so sp_sendmail should work.

Don't do this from a trigger. Let the trigger drop data in a table and then use a job that checks the table...

I tend to agree with Paul. Adding columns to support different characteristics might be breaking a normal form and repeating data for no reason. It is also harder to search...

There's a default trace as well. Search that, it might have the info you need if you check it soon after the event.

We don't know what your XML looks like or the table. We don't know the data, and you didn't give the error.

Please provide more details.

Moved to XML forum