Viewing 15 posts - 15,631 through 15,645 (of 22,219 total)
TheSQLGuru (3/26/2010)
ss-457805 (3/25/2010)
Grant, You are a genius. The query has come down to 6 secs with your recommendations.Thank you.
Oy vey - there goes Grant's ego!! 😀
No, no. My ego...
"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
March 26, 2010 at 8:15 am
The problem is you're explaining the table and it's size and that you have a problem, but you're not describing what the problem is. Are you having trouble on inserts?...
"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
March 26, 2010 at 8:10 am
Those things you're looking at are considered the best practices.
"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
March 26, 2010 at 7:09 am
Bhuvnesh (3/26/2010)
Grant Fritchey (3/26/2010)
You do know, as that table scales, this query will become slower and slower.
Frankly tell you this would be a intermediate/ working table ( prefebly 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
March 26, 2010 at 7:00 am
I don't think any index is going to help the query, but, I'd strongly suggest you identify the primary key on the table and make that a clustered index. This...
"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
March 26, 2010 at 6:50 am
I'm assuming you're using a lot of automatic settings, so your databases are probably on auto-grow. Nothing wrong with that, but now you need to monitor disk free space very...
"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
March 26, 2010 at 6:48 am
I think it looks OK. Test it on a different machine first to verify you get what 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
March 25, 2010 at 12:39 pm
Heck better Database Administrator than Database Developer. There's an average $20k difference in their salaries in the US. What I really do is develop databases, but I put down DBA...
"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
March 25, 2010 at 12:10 pm
The Dixie Flatline (3/25/2010)
ARID = Alternate Reality ID.I believe it's parameter 117, but I'd have to confirm that with Gail.
And that's a GUID right?
"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
March 25, 2010 at 11:52 am
You can't modify it while it's Read Only. You'll have to turn it off & turn it back on.
"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
March 25, 2010 at 11:37 am
ss-457805 (3/25/2010)
Grant, You are a genius. The query has come down to 6 secs with your recommendations.Thank you.
I'm certainly not a genius. That was just some of the easy stuff...
"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
March 25, 2010 at 11:20 am
I'm sorry, I'm not there and I don't know your structure. When you said this earlier:
But dalily we need all the columns data.
I thought that meant that you needed 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
March 25, 2010 at 8:29 am
Then possibly adding it might be in order. You've pretty much said that the access is by date. If you're principal access is by date, but you split it by...
"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
March 25, 2010 at 7:53 am
I guess it's a silly question, but why would you want to open 100 procedures all at the same time? You can't possibly look at or manipulate them all 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
March 25, 2010 at 7:14 am
I doubt it has anything to do with statistics. You're either hitting an error that is causing the rollback, the transaction is rolling back because the connection was dropped, or...
"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
March 25, 2010 at 7:09 am
Viewing 15 posts - 15,631 through 15,645 (of 22,219 total)