Viewing 15 posts - 17,701 through 17,715 (of 22,219 total)
Bob Hovious (4/16/2009)
First there was.... "The Thread".
Then came the "The Son of Thread".
Future Titles
The Other Thread
Revenge of The Thread
Return of 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
April 16, 2009 at 8:04 am
All I know is, if the THREAD starts to approach 5000 posts, I'm going to hunt it down & kill it before it passes me.
"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
April 16, 2009 at 8:00 am
Sounds pretty normal. As companies grow, a certain amount of tiers develop, at least for reporting purposes. I can talk to the CIO any time I want (I don't want...
"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
April 16, 2009 at 7:43 am
Maybe it's a delay? Steve would know. I'm sure he'll be by in a minute or three.
"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
April 16, 2009 at 7:41 am
Because every time you post to the forums you also get a point... there's another one.
"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
April 16, 2009 at 7:28 am
It really depends on the system. We have a few tables on a couple of databases where, due to some issues, we're running update stats a couple of times 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
April 16, 2009 at 6:00 am
I'm not aware of that one. Most of the showplan events are under the Performance section. Make sure you have "Show all Events" selected.
"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
April 16, 2009 at 5:50 am
The way to do something like that would be with at least two tables. The first table would hold the information about the person. The second table would hold relationships...
"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
April 16, 2009 at 5:38 am
I've seen a few posts like this where the odd query or three gets messed up by the upgrade, but I've never seen any large number of procedures get messed...
"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
April 15, 2009 at 5:15 pm
Bruce W Cassidy (4/15/2009)
I'm reading an article (it's work related, okay?) and I run across this paragraph:
"The first and most obvious reason is that the DW appliance...
"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
April 15, 2009 at 4:55 pm
GilaMonster (4/15/2009)
Bruce W Cassidy (4/15/2009)
[font="Verdana"]I didn't want to confuse issues by asking "aren't there some ANSI standards around character sets and collations?"[/font]
One question that pops to mind. Did ANSI create...
"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
April 15, 2009 at 4:53 pm
If I'm reading the data correctly, the estimated rows on the 2000 query is 13 right through, but the estimated values in 2005 are all over the place, from 1...
"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
April 15, 2009 at 9:44 am
I am confused as to why the performance is so different between the two, but the fact that performance is sub-optimal is because of the functions on the columns 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
April 15, 2009 at 8:05 am
You can use SET SHOWPLAN_ALL or SHOWPLAN_TEXT.
ALL provides more information but it's more difficult to read. Let's go with ALL despite the difficult, but you can post both.
"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
April 15, 2009 at 8:03 am
Two things.
First, and most important, the costs displayed in execution plans are estimates. They are not accurate measures of anything. While you may or may not see a cost go...
"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
April 15, 2009 at 7:30 am
Viewing 15 posts - 17,701 through 17,715 (of 22,219 total)