Viewing 15 posts - 11,971 through 11,985 (of 22,214 total)
Robert Heynen-454800 (8/24/2011)
You mentioned a transaction earlier. To...
August 24, 2011 at 9:50 am
It's not at all unheard of to modify data, a lot, and query it at the same time. It's pretty standard in fact. But, you have set expectations and spend...
August 24, 2011 at 8:42 am
Make sure that the delete and insert (it's not an update) are within a single transaction. That will prevent missing data during a query and should help, a bit, with...
August 24, 2011 at 5:55 am
In addition to the good advice given by Lutz, assuming these are lookup tables, we built a database that held the standard values for all lookup data. We only ever...
August 24, 2011 at 5:49 am
Roy Ernest (8/23/2011)
Grant Fritchey (8/23/2011)
Roy Ernest (8/23/2011)
August 23, 2011 at 10:39 am
GilaMonster (8/23/2011)
Ninja's_RGR'us (8/23/2011)
Grant Fritchey (8/23/2011)
Ninja's_RGR'us (8/23/2011)
Awesome info.You guys should really get together and write books or talk @ PASS sometimes :hehe:.
Now what could you possibly talk about? :Whistling:
That's a great...
August 23, 2011 at 10:16 am
Roy Ernest (8/23/2011)
August 23, 2011 at 10:15 am
Ninja's_RGR'us (8/23/2011)
Awesome info.You guys should really get together and write books or talk @ PASS sometimes :hehe:.
Now what could you possibly talk about? :Whistling:
That's a great idea! Maybe next year,...
August 23, 2011 at 7:53 am
I'm not sure I understand the question.
Are you saying that you want to transmit a record, or records, to the other server, but only when a certain action is taken...
August 23, 2011 at 6:33 am
Parallel execution probably. Hard to know what to do without seeing the code though.
August 23, 2011 at 5:56 am
GilaMonster (8/23/2011)
Ninja's_RGR'us (8/23/2011)
Ok but what makes you take that call? How can you tell that it's not the index that's @ fault to generate the bad plan?
Stats tell the...
August 23, 2011 at 5:43 am
Excellent code. Nice article. Well explained.
But I have to say, articles like this really do make me nervous. It seems like a very healthy percentage of our fellow database professionals...
August 23, 2011 at 5:38 am
Ninja's_RGR'us (8/22/2011)
nawillia (8/22/2011)
August 22, 2011 at 6:23 pm
Thanks. I just try to help out.
Hey, I like technical books too. Everyone at my old job thought I was weird when I picked up Kalen Delaney's SQL Server 2008...
August 22, 2011 at 4:05 pm
Christi Wilson (8/22/2011)
August 22, 2011 at 3:33 pm
Viewing 15 posts - 11,971 through 11,985 (of 22,214 total)