Viewing 15 posts - 14,581 through 14,595 (of 22,227 total)
The faster query is getting a parallel execution (assuming I'm reading which of the two plans is the faster). That could explain the difference in execution times right there. But...
"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 3, 2010 at 8:05 am
jeff.mason (8/3/2010)
"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 3, 2010 at 7:56 am
I'd try SQLPing
"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 3, 2010 at 7:40 am
I'm not sure that I see a difference either, but, this:
RIGHT(RTRIM(InvoiceNumber),12)
Is going to absolutely kill performance. You can only ever get scans because of that. Functions on columns is a...
"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 3, 2010 at 7:32 am
Why are you trying to create an alias of the geography data type with the same name? Just use it as is.
Also, if you try running that script, as defined,...
"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 3, 2010 at 6:54 am
How about using SMO. Something like this works:
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SQLServer.SMO") | Out-Null
$Server = New-Object ('Microsoft.SQLServer.Management.Smo.Server') 'Servername'
$db = $Server.Databases["Test"]
$script = Get-Content c:\scripts\input.sql
$extype = [Microsoft.SQLServer.Management.Common.ExecutionTypes]::ContinueOnError
$db.ExecuteNonQuery($script,$extype)
"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 3, 2010 at 6:06 am
Lynn Pettis (8/2/2010)
Gianluca Sartori (8/2/2010)
Jeff Moden (8/2/2010)
Gianluca Sartori (8/2/2010)
BTW, my hourly rate is around 11 euros (14 dollars).
Wow! If that's actually true, that's WAY too low for someone of...
"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 2, 2010 at 10:17 am
Lynn Pettis (7/23/2010)
"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
July 23, 2010 at 10:42 am
Roy Ernest (7/23/2010)
Grant Fritchey (7/23/2010)
Ray K (7/22/2010)
Uh oh, bad blood starting to break out here . . .
Nah, the guy's taking a beating for something he didn't create. I know...
"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
July 23, 2010 at 8:56 am
sreedhar1.m (7/23/2010)
Do not use row and table locks.
A couple of questions. How do you go about not using locks? Aren't they pretty much required by the system when it updates...
"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
July 23, 2010 at 4:57 am
Take a look at a function called sp_help. I think that might move you in the direction you wish to go.
"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
July 23, 2010 at 4:48 am
prakskarry (7/22/2010)
"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
July 23, 2010 at 4:22 am
WayneS (7/22/2010)
Grant Fritchey (7/22/2010)
WayneS (7/22/2010)
How does one go about creating a connect item? I think I've got about a dozen to submit on indexes.....
It's not hard. Go to connect.microsoft.com 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
July 23, 2010 at 4:16 am
Ray K (7/22/2010)
Uh oh, bad blood starting to break out here . . .
Nah, the guy's taking a beating for something he didn't create. I know the feeling all 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
July 23, 2010 at 4:15 am
MegaDBA (7/22/2010)
I think what Joe points out is just...
"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
July 22, 2010 at 12:50 pm
Viewing 15 posts - 14,581 through 14,595 (of 22,227 total)