Viewing 15 posts - 16,816 through 16,830 (of 22,219 total)
Is there an index in Opportunities on the AccountID? Are your indexes defragmented and the statistics up to date? How selective is the data within the Account table?
Based on what...
"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
July 31, 2009 at 7:53 am
It looks OK. You don't need to use a CTE to do the UPDATE, you can simply UPDATE... FROM and select what you need, but it won't change the overall...
"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
July 31, 2009 at 7:34 am
I guess my question is, why would you NOT go to one of these events? Fear that maybe the people presenting don't know what they're talking about? So leave the...
"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
July 31, 2009 at 7:32 am
It could be compile time or the time needed to move the data into cache or both.
"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
July 31, 2009 at 6:02 am
You must be getting a scan because you're not going to see an index seek when you have functions on columns like that. Like Gail says, post the code, structure,...
"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
July 31, 2009 at 6:01 am
No, an index hint doesn't change the order. The only way to affect the order of the data returned is to use an ORDER BY clause. That will take advantage...
"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
July 31, 2009 at 5:50 am
Many of the SSIS operators have the ability to pull rows with errors into a seperate path where you can store them, fix them, whatever, all without shutting down the...
"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
July 31, 2009 at 5:45 am
There's only been one large free SQL specific event locally. I presented at it, and helped put it on (although Adam Machanic did most of the work), which technically means...
"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
July 31, 2009 at 5:40 am
Rajesh kasturi (7/31/2009)
I knew some ways to get rid of tempdb issue.
Why I posted the question is,
Who expects reply to this quesion.
I agree with you, I am still...
"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
July 31, 2009 at 5:37 am
Yeah, I'm with Jeff on this. You can rely on TRUNCATE resetting to the original definition. I have not seen "0" popping up, ever, after rebuilding a table, truncating, 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
July 31, 2009 at 5:34 am
Actually though, that's what views are for. If you really don't want the internal's available, a view masks it perfectly. You could run into issues though if you see lots...
"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
July 30, 2009 at 12:52 pm
And then a thorough code review (we're talking proctology exam) to determine if there's one procedure with a problem or if there's a systemic issue with all the code being...
"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
July 30, 2009 at 12:30 pm
Documentation and discipline are about the only things that come to mind. I've never tried doing something like this nor heard of anyone doing it successfully.
"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
July 30, 2009 at 12:25 pm
I agree. Other than masking the columns behind a view, there's no real way to do this.
BTW, that's by design. SQL Server is not meant to be the presentation layer....
"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
July 30, 2009 at 11:58 am
Ronnie.Patton (7/30/2009)
We will most likely be doing its a reports database that needs to be a copy of the production database at some intervial behind. 1 hour...
"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
July 30, 2009 at 11:16 am
Viewing 15 posts - 16,816 through 16,830 (of 22,219 total)