Viewing 15 posts - 20,161 through 20,175 (of 22,226 total)
Looking at the execution plan, I'd try creating a second index, just on fk_tbl_visits_id. There's no guarantee it's going to work. 1m rows out 60m has a .0167 ratio, which...
"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 13, 2008 at 7:08 am
Purist anything in databases is usually a sign for disaster. There are places where an identity column as a PK and as FK's in all the related tables not only...
"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 13, 2008 at 6:55 am
When you ran the trace did you also see two different times on the server? I understand the client saw two times, but was it the same on the server?
Oh,...
"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 13, 2008 at 6:16 am
Should you "have to" do extra work? No. Are you going to in most situations. Yes.
It's kind of the nature of the beast. If you have tasks that have 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 13, 2008 at 6:11 am
While that may be true, SQL Server is not Access. There's no way to ensure physical order of the data returned without applying some type of order to the statement....
"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 13, 2008 at 6:06 am
Are you seeing two different execution plans 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
June 12, 2008 at 1:19 pm
FWIW, SQL Server 2008 has the same stupid problem.
"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 12, 2008 at 12:46 pm
Not knowing your system, your code or any special circumstances that you're laboring under, I'd go with my standard set. I've got them documented here[/url].
"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 12, 2008 at 12:34 pm
It doesn't give enough details on that page to determine if there's a funky business requirement or even if that initial model is updated in the demo. I'm still falling...
"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 12, 2008 at 11:45 am
No, I haven't gone there yet. Actually, I keep forgetting that dmv exists.
Yeah, it's working just fine.
"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 12, 2008 at 11:40 am
It might be possible in Access. I'm happy to say, I wouldn't know how to go about it at all.
"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 12, 2008 at 11:38 am
Unless there's a pretty major application or performance reason, I'd have to agree that this is a crappy "real world" example.
"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 12, 2008 at 11:18 am
SQL Server is not Access.
Access is doing two things there. First it's maintaining referential integrity between two tables. Second, it's providing you with a GUI (graphical user interface) to look...
"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 12, 2008 at 11:15 am
If you're in the GUI, you can simply right click the job and select "Script Job as... CREATE to" and pick where you want the script stored. Edit any localization...
"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 12, 2008 at 11:04 am
I agree with you. Your MaxDop should be 8 or less.
As to the main question. I'd run a trace out to a file and start working on the longest running...
"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 12, 2008 at 10:59 am
Viewing 15 posts - 20,161 through 20,175 (of 22,226 total)