Viewing 15 posts - 15,646 through 15,660 (of 22,227 total)
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
Looking at it, you're getting almost nothing but clustered index scans. That means it's reading every single row on the table. Things in the queries that are causing this include:
CellGroupName...
"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:06 am
ekknaveen (3/24/2010)
I need the help to solve the below mentioned questiones.
1. <>. > =. LIKE what is the order as per performance
2. select * from tab1 where lower(name)='name' is fast...
"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 6:52 am
It sounds like a classic design error on normalization. Yes, given the opportunity, I'd suggest redesigning the structure and migrating the data. It won't be that hard and you should...
"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 6:46 am
The uniquifier (or uniqueifier) is a 4byte integer value. So from that you can estimate the cost to the size of the index. So that not only increases the size...
"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 6:34 am
virgilrucsandescu (3/24/2010)
And the last chapter (the checklist) should be on the desk...
"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 6:05 am
I agree with Gus and I'll add that I still learn more when I answer a question wrong and it gets fixed by one of the SQL-Monsters that run around...
"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 24, 2010 at 12:35 pm
Steve Jones - Editor (3/24/2010)
...many of the more vocal people on the East Coast...
Now who the heck are you talking about?
"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 24, 2010 at 10:29 am
Viewing 15 posts - 15,646 through 15,660 (of 22,227 total)