Viewing 15 posts - 17,236 through 17,250 (of 22,219 total)
Based on the research and testing I've done with it, it's unlikely to cause much negative impact. It's also unlikely to cause much positive impact except in special circumstances. I'm...
"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
June 11, 2009 at 6:11 am
YSLGuru (6/10/2009)
"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
June 10, 2009 at 1:27 pm
RBarryYoung (6/10/2009)
"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
June 10, 2009 at 8:21 am
kladibeeto (6/10/2009)
Thank you for your effort I also find this on Microsoft site, but I am still not sure 🙂
How you can not be sure? Microsoft may be a large,...
"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
June 10, 2009 at 7:49 am
A dump is just a backup. They're EXACTLY the same thing. Dump is just old terminology. I wouldn't do it for them. I get really, really, pissy when people demand...
"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
June 10, 2009 at 7:46 am
When you're testing, take a look at the estimated rows for the actual values and the variables. I suspect you'll see substantial differences. For the variables you'll see an average...
"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
June 10, 2009 at 7:44 am
Grant Fritchey (6/10/2009)
Lynn Pettis (6/10/2009)
MarkusB (6/10/2009)
Grant Fritchey (6/10/2009)
MarkusB (6/10/2009)
Any psychics around who can help this onehttp://www.sqlservercentral.com/Forums/Topic732091-266-1.aspx
I can't read minds, but I can see the future...
I see... I see... a dba-wanna-be...
"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
June 10, 2009 at 7:40 am
Lynn Pettis (6/10/2009)
MarkusB (6/10/2009)
Grant Fritchey (6/10/2009)
MarkusB (6/10/2009)
Any psychics around who can help this onehttp://www.sqlservercentral.com/Forums/Topic732091-266-1.aspx
I can't read minds, but I can see the future...
I see... I see... a dba-wanna-be on 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
June 10, 2009 at 7:39 am
WayneS (6/10/2009)
Grant Fritchey (6/10/2009)
Well done. Extremely thorough, accurate, well written... but what's with the attached Word file?
I wrote the article in Word, and I had asked Steve to include it...
"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
June 10, 2009 at 7:38 am
Grumpy DBA (6/10/2009)
Developer 1: "Hey, it's almost quitting...
"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
June 10, 2009 at 7:33 am
Actually, based on what you describe, I'm not sure I'd use SSIS to do the job. I think I'd drop out to PowerShell to manage this. If you do it...
"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
June 10, 2009 at 7:29 am
Yes, getting that many updates into a single statement is the best mechanism. You should experiment between using XQuery directly on the XML and loading the data into a temporary...
"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
June 10, 2009 at 7:26 am
Percentage costs are based on the estimated costs and as Christopher pointed out, estimated costs are just that, estimated. They're based on the statistics available to the optimizer and are...
"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
June 10, 2009 at 7:21 am
sys.dm_tran_locks is going to have the locking information, although I'm not sure if it will show lock escalation as it occurs. Once you're in there, you can get the sessionID...
"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
June 10, 2009 at 7:16 am
When in doubt about thing released by Microsoft, the best source is Microsoft. You can go to the MSDN web site. Finding "What's New in SQL Server 2005 SP3" will...
"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
June 10, 2009 at 7:09 am
Viewing 15 posts - 17,236 through 17,250 (of 22,219 total)