Viewing 15 posts - 18,826 through 18,840 (of 22,226 total)
I don't see the execution plan...
"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
January 8, 2009 at 8:50 am
jonathan allen (1/8/2009)
OrgName
FROM Organisation
ORDER BY OrgName
Clustered Index Scan on Primary Key - 95%
Sort (on Indexed OrgName...
"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
January 8, 2009 at 8:40 am
The execution plan is your friend.
That will tell you what's occurring within the query.
"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
January 8, 2009 at 8:28 am
I would put the customer information in a common table. 40 customers = 40 tables, with 40 different queries and 40 different indexes and 40 different maintenance plans... Oh, 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
January 8, 2009 at 7:32 am
Well, there are no guarantees, but I'd say, it depends on what your script is doing. Your standard, every day, every second, script that's updating a set of tables... 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
January 8, 2009 at 6:04 am
I agree with Peso.
Think about it. First, you'd need 365 seperate tables for just one year worth of data. Second, your queries would have to be changed, every single day,...
"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
January 8, 2009 at 6:01 am
I've got SQL Server 2000, 2005 and 2008 running on one machine along with three different copies of Express. All with no issues.
My understanding is that you can install 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
January 8, 2009 at 5:47 am
From what you've laid out, it sounds OK. Usually, when dealing with a many-to-many table like this, I let the foreign keys also define the primary key. Otherwise you need...
"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
January 8, 2009 at 5:42 am
If the errors you hit result in a disconnection from SQL Server, there's nothing that can be done to catch or handle those errors. As for the rest, look up...
"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
January 8, 2009 at 5:41 am
I don't understand either.
Can you show what you've tried that hasn't worked?
"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
January 7, 2009 at 1:04 pm
It sounds like you need to get rid of the cursor and just run a query using the data in a join or possibly as part of the where clause.
"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
January 7, 2009 at 1:02 pm
BTW, anyone else notice that all you have to do is bring up alcohol and the posting volume goes through the roof?
You buncha lushes.
"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
January 7, 2009 at 12:56 pm
Steve Jones - Editor (1/7/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
January 7, 2009 at 12:42 pm
Except that this portion of the thread started with Steve making fun of Jeff.
Well, he lives in MI. Aren't we supposed to make fun of him?
"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
January 7, 2009 at 11:19 am
I guess you can't argue with that. The worst part is that so many of them have moved North to NH and corrupted a perfectly good state.
Agreed, but 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
January 7, 2009 at 11:06 am
Viewing 15 posts - 18,826 through 18,840 (of 22,226 total)