Viewing 15 posts - 20,341 through 20,355 (of 22,226 total)
Oooh. Excellent. I've got a lot of respect for Aikido. Very useful techniques. We've had people teach seminars on it so that we at least have a level of understanding...
"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 23, 2008 at 6:56 am
I'd start with Itzik Ben-Gan's two books, Inside T-SQL Querying and Inside T-SQL Programming.
"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 23, 2008 at 6:51 am
That's only one insert every 5.76 seconds. Even if you assume that all the records will come in over a 12 hour period that's only one every 2.5 seconds. Even...
"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 23, 2008 at 6:49 am
It's just guesses without some code and structure.
If you step through the process, running the steps manually, can you see the data move appropriately? That's where I'd start.
"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 23, 2008 at 6:44 am
You can certainly update from an inner join. That's easy. The trick is to get the join right to start with.
Instead of doing an update, write the whole thing as...
"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 23, 2008 at 6:14 am
Since these are all pulling from the same table (except one of the queries) have you looked at either using an OUTER join or even an INNER join to pull...
"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 23, 2008 at 6:05 am
I started in Seido in NYC where I got to green. Then I moved and restarted in Goju Ryu where I got to green. That dojo imploded. So I looked...
"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 23, 2008 at 5:57 am
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
Viewing 15 posts - 20,341 through 20,355 (of 22,226 total)