Viewing 15 posts - 7,411 through 7,425 (of 22,226 total)
It's hard to argue with that. If you don't need it, don't create it.
The key point is that the execution plan for a batch is created all at once. 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
October 9, 2014 at 6:27 am
santoshkal (10/9/2014)
after using where clause also its taking 100% cost ?any other way to improve ?
thanks
That's a measure of an estimate in comparison to measures of other estimates. 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
October 9, 2014 at 6:24 am
sqldriver (10/9/2014)
Grant Fritchey (10/9/2014)
"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
October 9, 2014 at 6:21 am
I wouldn't suggest passing the value as a string. You're potentially taking away the ability of the optimizer to use parameter sniffing (a good thing the majority of the 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
October 9, 2014 at 5:52 am
Just so we're clear, those really are two very different queries. One references a single table. The other references two tables.
I agree with the other comments, but I think...
"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
October 9, 2014 at 5:50 am
You can get a determination of the performance and usefulness of an index three ways. First, you measure the time on a given query before and after applying the index....
"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
October 9, 2014 at 5:48 am
I like Eddies rules. The one thing I would add is that, unlike 2000, in 2005 and up, you're going to see statement level recompiles, not procedure level recompiles (unless...
"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
October 9, 2014 at 3:40 am
The average range rows and the equivalent range rows seem to be pretty accurately distributed. They're extremely close to being roughly the same, except for that 38 outlier.
The statistics are...
"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
October 9, 2014 at 3:36 am
You've created 100,000 rows, but they are in 1,000,000 buckets in your hash. That's a lot of empty space that's going to be scanned. I'd guess that's why you're seeing...
"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
October 8, 2014 at 12:43 pm
Nice work.
And well done on asking for help the best way possible. Keep coming back and asking for help like that and I know you'll receive it on this site.
"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
October 8, 2014 at 4:35 am
The one tool I've used for the last fourteen years is SQL Compare[/url]. This is such a common task, it makes sense to get a tool that will do 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
October 8, 2014 at 4:34 am
Create a WHILE loop without an exit and keep updating a row over and over. It won't be fast, but you'll see the transaction log grow. Make sure you 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
October 8, 2014 at 4:24 am
djj (9/30/2014)
SQLRNNR (9/29/2014)
"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
October 7, 2014 at 11:41 am
djj (9/29/2014)
I tell them they should only store a standardized value. A prime example of...
"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
October 7, 2014 at 11:38 am
Compile time for the plan is stored with the plan itself. If you look at the graphical operator it can be seen in the first operation of the plan (usually...
"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
October 7, 2014 at 5:10 am
Viewing 15 posts - 7,411 through 7,425 (of 22,226 total)