Viewing 15 posts - 16,471 through 16,485 (of 22,219 total)
Silverfox (9/22/2009)
How much can you receive for aricles posted here?, just out of comparision 😀
Less, but the article length requirement here is not as long. You don't go through 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
September 22, 2009 at 5:35 am
Roy Ernest (9/21/2009)
Damn... Thats pretty good. 🙂 So the standard will be pretty high... Then my article is probably going to be rejected... :hehe:
I'm not sure how high the standard...
"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
September 21, 2009 at 7:23 pm
Yeah, you can't really directly compare one execution plan to other as such, you just evaluate each one to see if there are issues.
Yes, it's a Star Fury. B-5 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
September 21, 2009 at 1:04 pm
Assuming this is a multi-statement query, you could try capturing the Statement completion event within a trace. It's going to return an awful lot of data, so you need 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
September 21, 2009 at 12:56 pm
Although, usually, half as many reads is pretty much the end of the story. I'd check the execution plan though, see what differences there are there.
"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
September 21, 2009 at 12:40 pm
Maxer (9/21/2009)
Table1 and Table2.
I UNION both and add a column called "Origin" that says "Table1" for table 1 and "Table2" for table...
"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
September 21, 2009 at 12:38 pm
I'm sorry, I'm reading through the code there and I'm not sure what your error message 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
September 21, 2009 at 12:36 pm
Lynn Pettis (9/21/2009)
Grant Fritchey (9/21/2009)
Lynn Pettis (9/21/2009)
Grant,One very important question, copyright on the article, who owns it?
You do.
We get exclusive rights for... some period of time I don't recall, 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
September 21, 2009 at 12:10 pm
Lynn Pettis (9/21/2009)
Grant,One very important question, copyright on the article, who owns it?
You do.
We get exclusive rights for... some period of time I don't recall, a year or less. It's...
"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
September 21, 2009 at 11:38 am
Lynn Pettis (9/21/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
September 21, 2009 at 9:32 am
There are a whole series of connection settings you can modify. Take a look at the server properties for the default set. Implicit transactions, cursor close on commit, ansi warnings,...
"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
September 21, 2009 at 7:48 am
It really depends on what the queries are doing. A select statement without any temp tables, table variables, or ORDER BY clauses, that pulls data through seeks and joins through...
"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
September 21, 2009 at 6:49 am
Check the connections settings of both to ensure they're making the same choices regarding ANSI NULL's, etc. That can make a big difference in performance. Also, if you're trying 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
September 21, 2009 at 6:47 am
As far as I know it's because you can write procedures and not store them or store the procedures.
It's just a reasonably descriptive name.
Why are you asking about it &...
"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
September 21, 2009 at 6:40 am
It's a very good idea to turn on TRACEFLAG 1222. It can be difficult to interpret, but at least you're assured of capturing the information as each deadlock occurs. Otherwise,...
"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
September 21, 2009 at 6:35 am
Viewing 15 posts - 16,471 through 16,485 (of 22,219 total)