Viewing 15 posts - 11,506 through 11,520 (of 22,224 total)
I'd go for Option B too.
"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
December 16, 2011 at 9:14 am
SQL Kiwi (12/16/2011)
Grant Fritchey (12/16/2011)
It generated an ugly parallel execution plan, but I'm not getting a deadlock. What did I do wrong?
Replying to the wrong post here (I see 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
December 16, 2011 at 8:17 am
SQL Kiwi (12/16/2011)
Grant Fritchey (12/16/2011)
I'm not even marginally surprised that you have one of these sitting around. Thank you!
Clearly I will need to work harder at surprising you in...
"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
December 16, 2011 at 7:56 am
SQL Kiwi (12/16/2011)
Grant Fritchey (12/16/2011)
I'm not even marginally surprised that you have one of these sitting around. Thank you!
Clearly I will need to work harder at surprising you in...
"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
December 16, 2011 at 7:51 am
SQL Kiwi (12/16/2011)
Grant Fritchey (12/16/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
December 16, 2011 at 7:38 am
When I'm teaching reading execution plans, my favorite moment is when I show a delete query which then hits 15 tables doing RI lookups and I ask people, "So, still...
"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
December 16, 2011 at 7:23 am
I think you're already doing the right thing, adding indexes to support the lookups required for referential integrity. The only other thing you could do is drop the RI while...
"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
December 16, 2011 at 7:08 am
jcrawf02 (12/16/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
December 16, 2011 at 7:05 am
Threadizens!
Anyone have a script that will reliably generate a deadlock from a single process? I need to be able to repeatedly generate a parallelism deadlock for some internal testing. I...
"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
December 16, 2011 at 7:04 am
Don't be surprised when those values constantly read almost exactly the same. Some counters that are going to change that will show you how things are behaving would include:
memory:pages/sec, page...
"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
December 15, 2011 at 4:47 am
You don't want your average business person mucking about in your database. First thing is to have something in front of it to make it easy for those people.
Next, 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
December 15, 2011 at 4:35 am
sqldba2k8 (12/15/2011)
in software industry most of the working people are fake.
You have to define fake. Is fake being that you don't know everything about everything? Yes, we're all fake. 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
December 15, 2011 at 4:27 am
Cleaning up unused indexes is an OK use for your time, but, you need to be aware, sys.dm_db_index_usage_stats only records information since the last time the server was restarted (and...
"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
December 15, 2011 at 4:20 am
Your approach is basically sound, yes. Be sure that two hours is how much data the business is prepared to lose in the event of a catastrophic issue. Also, test...
"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
December 15, 2011 at 4:15 am
RSP (12/14/2011)
<<Maybe that index will save you tons...
"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
December 14, 2011 at 8:06 am
Viewing 15 posts - 11,506 through 11,520 (of 22,224 total)