Viewing 15 posts - 20,341 through 20,355 (of 22,219 total)
I'll go one further, use Matt's solution. That looks good from where I sit.
"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
May 22, 2008 at 3:01 pm
GilaMonster (5/22/2008)
Steve Jones - Editor (5/22/2008)
"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
May 22, 2008 at 12:54 pm
Lots of null columns. Lots. Without the query it's hard to comment, but I'll bet it's doing a table scan. Have you looked at the execution plan for the query?
"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
May 22, 2008 at 10:39 am
You have an index, but is it being used properly? What do the execution plans look like? What's the selectivity of the data in that index, meanin, how unique is...
"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
May 22, 2008 at 10:35 am
akeelm_uk (5/22/2008)
That is one area where I feel certification can be good, it encourages you 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
May 22, 2008 at 8:15 am
I'm not actively against certifications, but I sure don't care about them. I'm much more interested in what you know and how you show it than that you passed 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
May 22, 2008 at 7:26 am
Also, while lots of people may have one piece of knowledge or another, maybe a full set of the knowledge has never been put in one place before. I wrote...
"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
May 22, 2008 at 7:18 am
Sorry I wasn't helpful. It's just not inherent in the tool. We have a large number of developers & dba's hitting a large number of servers. I sometimes wish we...
"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
May 22, 2008 at 6:52 am
What he said. Sorry I didn't fully understand the problem. The key point is a view is just a mask on top of a table (or tables). It doesn't actually...
"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
May 22, 2008 at 6:48 am
I'm not entirely sure what your problem is. The example code won't compile. I ran this:
CREATE VIEW MyView
AS SELECT Col1
FROM MyTable
...
"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
May 22, 2008 at 6:18 am
If your query execution timeout is set to zero ("0") in Management Studio, you shouldn't be seeing a 30 second timeout. Are these queries crossing servers in some way that...
"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
May 22, 2008 at 6:01 am
I'm not entirely sure, but three things come to mind. First, the engine & optimizer behave differently enough that in this situaion 32 is just better than 64. Second, differences...
"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
May 22, 2008 at 5:57 am
As others have already pointed out, to really answer the question you need to post some structures and some sample code.
But, taking a stab at it, it sure sounds like...
"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
May 22, 2008 at 5:41 am
Now, now... we're stepping outside the bounds of the experiment.
I'll have to see what I can do with a materialized view though. That's a good idea just to try out.
"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
May 21, 2008 at 2:13 pm
Or just use good ole' fashioned bcp.
"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
May 21, 2008 at 1:25 pm
Viewing 15 posts - 20,341 through 20,355 (of 22,219 total)