Viewing 15 posts - 12,241 through 12,255 (of 22,219 total)
Is the table a part of a join? Is it the bottom part of a Loop join perhaps? How many executions are there? Does that equal the number of rows?
"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 23, 2011 at 7:27 am
Where'd you get the pictures of my yard?
"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 22, 2011 at 12:53 pm
Nope.
That text column is going to be a limiter for you.
"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 22, 2011 at 7:38 am
ROLLBACK is used when you have an open transaction to undo the changes for that transaction. It doesn't work after transactions have already been committed. This article [/url]I wrote at...
"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 22, 2011 at 4:57 am
No, you could go one more level deep. Have three tables. One for the measure, one for the measure type (height, width, weight), and one for the business measure type...
"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 21, 2011 at 2:19 pm
No, I would have gone a different way. A heigh table, a width table, etc., and then a Type table that can be mapped to each of the other tables...
"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 21, 2011 at 11:58 am
Compusol (6/21/2011)
"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 21, 2011 at 11:21 am
The cluster is on ID but you're searching on DOCID. Unless that's a typo, that would explain why you're getting the scan.
"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 21, 2011 at 8:47 am
Sumanta Roy (6/21/2011)
As you said ANSI 89 outer joins are no longer supported in 2008, I have one doubt. If we change the database compatiblity level to SQL server...
"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 21, 2011 at 7:03 am
I'd break out the Height, Length, Depth, Weight measures into... probably, four different tables, each with a type lookup into a lookup table. I'd consider making a single measure table,...
"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 21, 2011 at 5:02 am
It's less than 1gb? Why not look into using SQL Azure? Sounds like a perfect solution.
"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 21, 2011 at 4:59 am
But, the key point here is, that you can't use nolock with a delete. A delete operation absolutely must lock as it deletes, no options. If you issue a nolock...
"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 21, 2011 at 4:58 am
If there is no blocking occurring, then your hardware is extremely slow, or there is a problem with your code.
As was already stated, there's not enough information here to provide...
"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 21, 2011 at 4:55 am
Microsoft books online shows exactly how to configure your system for performing stand alone installs through the command line. You can then do this from a batch file or, better...
"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 21, 2011 at 4:53 am
Lynn Pettis (6/21/2011)
"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 21, 2011 at 4:06 am
Viewing 15 posts - 12,241 through 12,255 (of 22,219 total)