Viewing 15 posts - 17,086 through 17,100 (of 22,226 total)
Yeah, that's a huge query and it's going to take a long time to compile. What's more, the size of it, the number of tables it hits, it's going 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 29, 2009 at 8:09 am
Paul White (6/29/2009)
Grant Fritchey (6/29/2009)
I'm not sure I'd call it proper since I occupy it, but, oh yeah, it's completely a Dilbert style cube. I work for an insurance company.
Well...
"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 29, 2009 at 6:57 am
You'll have to define the context in which you're using these terms. For example, you say comparison and I think that you're referring to the WHERE clause or the JOIN...
"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 29, 2009 at 6:46 am
If this is a reporting system, it might need a larger tempdb. It's not just virtual tables (by these I assume you mean temp tables and table variables) that use...
"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 29, 2009 at 6:42 am
They should be good articles. They're taking the RSS feeds from all the best blogs and posting them up without attribution and frequently without links. It looks like this place...
"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 29, 2009 at 6:38 am
GilaMonster (6/29/2009)
Grant Fritchey (6/29/2009)
You're right about the DROPCLEANBUFFERS and FREEPROCCACHE.
Personally I prefer to run all test queries twice and ignore the times of the first result. That way, what I'm...
"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 29, 2009 at 5:40 am
Peso (6/29/2009)
But on 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
June 29, 2009 at 4:07 am
Paul White (6/28/2009)
Grant Fritchey (6/28/2009)
I've got that posted on my cube at work.You have a proper Dilbert-style cube? :w00t:
I'm not sure I'd call it proper since I occupy it, but,...
"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 29, 2009 at 4:03 am
RBarryYoung (6/28/2009)
Jack Corbett (6/28/2009)
GilaMonster (6/28/2009)
Lynn Pettis (6/27/2009)
"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 28, 2009 at 7:41 pm
mike_walsh (6/28/2009)
"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 28, 2009 at 7:39 pm
Paul White (6/28/2009)
Grant Fritchey (6/28/2009)
"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 28, 2009 at 7:31 pm
GilaMonster (6/28/2009)
Plus it's one plan per execution of the UDF. Also, you cannot trust statistics IO when you have a udf that does any form of data access.
I'm not sure...
"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 28, 2009 at 5:51 am
GilaMonster (6/26/2009)
Grant Fritchey (6/26/2009)
"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 28, 2009 at 5:44 am
David.Poole (6/26/2009)
He has some pearls of wisdom
1. It takes 18-24 months for the agile methodologies...
"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 28, 2009 at 5:39 am
mike_walsh (6/26/2009)
"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 28, 2009 at 5:24 am
Viewing 15 posts - 17,086 through 17,100 (of 22,226 total)