Viewing 15 posts - 22,936 through 22,950 (of 39,823 total)
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...
July 27, 2009 at 8:40 am
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...
July 27, 2009 at 8:37 am
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...
July 27, 2009 at 8:34 am
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...
July 27, 2009 at 8:26 am
I saw this in my notifications, thinking, great, another fun complaint for Monday.
And apparently you folks are getting ready for lunch. Enjoy!
July 27, 2009 at 8:26 am
are you talking the built in external stored procedures, or ones you've added?
July 27, 2009 at 8:15 am
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...
July 27, 2009 at 8:14 am
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...
July 27, 2009 at 7:50 am
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...
July 25, 2009 at 12:05 pm
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...
July 25, 2009 at 11:56 am
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,...
July 25, 2009 at 10:49 am
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...
July 25, 2009 at 10:47 am
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...
July 25, 2009 at 10:46 am
There's a default trace as well. Search that, it might have the info you need if you check it soon after the event.
July 25, 2009 at 10:44 am
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
July 25, 2009 at 10:42 am
Viewing 15 posts - 22,936 through 22,950 (of 39,823 total)