Viewing 15 posts - 11,896 through 11,910 (of 22,224 total)
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
You can't get zero i/o, ever. You have to have some i/o or you're neither querying or returning any data. So that goal is right out the window.
As far as...
"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 5, 2011 at 8:10 am
There's not enough information here to give you good info. First, the database tuning adviser is a pile of steaming brown stuff. It's recommendations are frequently useless and sometimes dangerous....
"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 5, 2011 at 8:03 am
forsqlserver (9/5/2011)
Just to be included in the answers
You don't have to do that. If you go to the top right of the page with the question on it and click...
"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 5, 2011 at 7:59 am
Viewing 15 posts - 11,896 through 11,910 (of 22,224 total)