Viewing 15 posts - 11,896 through 11,910 (of 22,227 total)
Roy Ernest (9/7/2011)
Grant Fritchey (9/7/2011)
https://www.livemeeting.com/cc/8000181573/join?id=33Z39D&role=attend&pw=f%5E%3E2mzT7H
I'm going on at 2300GMT or 7:00PM EDT
https://www.livemeeting.com/cc/8000181573/join?id=69K9DZ&role=attend&pw=f%5E%3E2mzT7H
You'll get close to 2 out of 7 hours...
"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
September 7, 2011 at 1:28 pm
You all know Gail is on right now? She's doing great:
https://www.livemeeting.com/cc/8000181573/join?id=33Z39D&role=attend&pw=f%5E%3E2mzT7H
I'm going on at 2300GMT or 7:00PM EDT
https://www.livemeeting.com/cc/8000181573/join?id=69K9DZ&role=attend&pw=f%5E%3E2mzT7H
You'll get close to 2 out of 7 hours of our precon this...
"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
September 7, 2011 at 12:27 pm
When you create a foreign key, it's a constraint, not an index. If you want an index on a foreign key, that must be created separately.
You can look at 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
September 7, 2011 at 5:48 am
Schadenfreude-Mei (9/7/2011)
SwayneBell (9/7/2011)
Grant Fritchey (9/7/2011)
Oh no, really? I thought she was only writing to me. Our relationship was built on a lie <sob>.
I was disappointed too Grant, what with my...
"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
September 7, 2011 at 5:45 am
Oh no, really? I thought she was only writing to me. Our relationship was built on a lie <sob>.
"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
September 7, 2011 at 3:51 am
Sounds like something going wrong on the Windows Server. Have you checked there for errors?
"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
September 7, 2011 at 3:50 am
ravindranath.s (9/7/2011)
SELECT DISTINCT UPP.ProductID,dbo.fnGetProductTestStatus(UPP.ProductID,@UserID) AS EndDate ,
FROM #UserProductProgression UPP
when i say like...
"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
September 7, 2011 at 3:48 am
Also, you're saying "similar" data sets, not identical data sets. Similar can be pretty radically different depending on the data distribution.
Also, no mention of any measure for contention. Are 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
September 7, 2011 at 3:40 am
Well done Gail. The place just wouldn't be the same without 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
September 7, 2011 at 3:24 am
106919046 (9/7/2011)
If your files change alot. I recommend you use incremental backup instead of deferential backup.
Recheck your backup task, see if it did...
"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
September 7, 2011 at 3:23 am
If the vendor won't support the upgrade, don't do it. Even if you only hit very minor issues, they can disavow all support and you're on your own. If 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
September 6, 2011 at 5:55 am
Then you shouldn't be surprised if it slows things down. Make sure you're running these processes at the slowest part of the day because they will affect each other. If...
"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
September 6, 2011 at 5:08 am
ananda.murugesan (9/5/2011)
I understand for IO never become 0.0.
Could you tell me, what is actual value output for most IO query and what is generally perfered value of IO...
"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
September 6, 2011 at 5:04 am
Temporary tables will cause the recompile. If the amount of data you're working with is small, say less than 200 rows, you could switch to table variables. These will not...
"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
September 6, 2011 at 4:55 am
It's not a very big table. Is there lots of contention? Other processes accessing it while you're attempting to defrag? That would explain the slow down.
"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
September 6, 2011 at 4:51 am
Viewing 15 posts - 11,896 through 11,910 (of 22,227 total)