Viewing 15 posts - 7,876 through 7,890 (of 22,226 total)
GilaMonster (6/27/2014)
Grant Fritchey (6/27/2014)
You have a MIN without an ORDER BY. That can lead to bad data
How? Top without an order by I can see, MIN (the minimum value)...
"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 27, 2014 at 2:52 pm
Joy Smith San (6/27/2014)
You can change it manually.
Yes
"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 27, 2014 at 2:50 pm
Chord77 (6/27/2014)
He wants my primary role to be process improvement and creation. I've done it (successfully) in the past, but that wasn't 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 27, 2014 at 2:49 pm
Almost impossible to give you substantial suggestions without at least seeing the execution plan, but a couple of points. Do you really need the DISTINCT clause. That's going to cause...
"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 27, 2014 at 8:11 am
Anyone think they can help this person? I think they really need it, and what's more, deserve it. 6.5? Please, no.
"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 27, 2014 at 8:09 am
Wow! Well done.
I'm mainly working 2008 & up, so I'll be happy to help with that stuff.
Good luck on the DTS issue.
"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 27, 2014 at 8:07 am
Since your question is 2000 specific, you might get better responses posting it in a 2000 forum. I haven't touched a 2000 server for several years now, let alone messed...
"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 27, 2014 at 7:18 am
That's an indication the optimizer thought that operator would be executed 200 times. It may or may not be depending on the accuracy of your statistics. You can run 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 27, 2014 at 6:53 am
Without the plan itself, not just a picture, it's really hard to say. Can you post the execution plan? An actual plan would be preferable to an estimated one.
"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 27, 2014 at 4:42 am
You might also want to look up sp_whoisactive by Adam Machanic.
"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 27, 2014 at 4:41 am
Assuming you're talking about two different server instances and two different sets of file locations so that each server is pointing to a different file, the names don't need to...
"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 27, 2014 at 4:40 am
And chances are really good if you don't have a DBA around that there are statistics inside the databases that need to be updated, there may be query tuning opportunities,...
"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 27, 2014 at 4:38 am
There are two kinds of execution plans, estimated and actual. To get an estimated plan inside SQL Server Management Studio, you simply type:
EXEC myNewProc 'myparameter';
Highlight that command and within Management...
"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 27, 2014 at 4:37 am
Microsoft and the Books Online are our bestest friends in the world.
"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 27, 2014 at 4:30 am
No, it should work on 2012. It would have been a good idea to get the entire message and everything that it said is incompatible. But according to Microsoft, it's...
"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 26, 2014 at 12:41 pm
Viewing 15 posts - 7,876 through 7,890 (of 22,226 total)