Viewing 15 posts - 16,486 through 16,500 (of 22,226 total)
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
I wouldn't be surprised if you can tune it further. Nice to hear that it's working better.
"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 19, 2009 at 5:45 am
Yes, but what is occuring inside the function? Is it a single statement function with a query against a single table just with parameters or are multiple tables involved in...
"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 19, 2009 at 5:44 am
Lynn Pettis (9/18/2009)
Grant Fritchey (9/18/2009)
Lynn Pettis (9/18/2009)
Grant Fritchey (9/18/2009)
Lynn Pettis (9/18/2009)
Grant Fritchey (9/18/2009)
Lynn Pettis (9/17/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 19, 2009 at 5:30 am
Roy Ernest (9/18/2009)
I know I am not the best article writer.. 🙂 But I think I will give it a try if I ever am able to make some time....
"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 19, 2009 at 5:27 am
I'm a little confused on the idea of a function vs. a join. If you have two sets of data that you want to put together, you have to do...
"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 18, 2009 at 1:16 pm
Lynn Pettis (9/18/2009)
Grant Fritchey (9/18/2009)
Lynn Pettis (9/18/2009)
Grant Fritchey (9/18/2009)
Lynn Pettis (9/17/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 18, 2009 at 1:06 pm
Lynn Pettis (9/18/2009)
Grant Fritchey (9/18/2009)
Lynn Pettis (9/17/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 18, 2009 at 12:29 pm
Oh, and, in cases like this, all the execution plans are going to be relevant.
"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 18, 2009 at 12:25 pm
Viewing 15 posts - 16,486 through 16,500 (of 22,226 total)