Viewing 15 posts - 11,971 through 11,985 (of 22,219 total)
There is something in 2008R2 called Master Data Services, but the strictures for using it were so severe we couldn't get it to fly within our environment. We went the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 24, 2011 at 11:43 am
Welsh Corgi (8/24/2011)
I did not mean to offend you.I did not mean it that way.
No offence at all. I was joking. Sorry that came off harsh. It sure wasn't meant...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 24, 2011 at 11:42 am
Welsh Corgi (8/24/2011)
Grant Fritchey (8/22/2011)
Everyone at my old job thought I was weird when I picked up Kalen Delaney's SQL Server 2008 Internals and just started reading.
If they thought you...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 24, 2011 at 10:57 am
Oh yeah, it's going to block.
It's all about choices. You want to get rows back and not fall into the crack between a delete and an insert... gotta have the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 24, 2011 at 10:56 am
You're trying to build an index off of a field or fields that is too large. You have to use less or smaller fields to build the index. There is...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 24, 2011 at 9:55 am
Robert Heynen-454800 (8/24/2011)
You mentioned a transaction earlier. To...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 24, 2011 at 5:49 am
Roy Ernest (8/23/2011)
Grant Fritchey (8/23/2011)
Roy Ernest (8/23/2011)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 23, 2011 at 10:16 am
Roy Ernest (8/23/2011)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 23, 2011 at 6:33 am
Parallel execution probably. Hard to know what to do without seeing the code though.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 23, 2011 at 5:56 am
Viewing 15 posts - 11,971 through 11,985 (of 22,219 total)