Viewing 15 posts - 18,091 through 18,105 (of 22,226 total)
Yeah, you'll have a few joins, it's still not that many and the indexing should be very simple. The one thing I'd suggest, instead of trying to pivot the data...
"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
March 6, 2009 at 6:59 am
You've just hit the hardest part of the migration out of 2000, retiring DTS. I'd suggest a mixed approach. Run the Upgrade Adviser and let it scan your DTS packages....
"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
March 6, 2009 at 6:50 am
It's the leading edge that makes the most difference, yes. I'd drop one of the two indexes.
"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
March 6, 2009 at 6:43 am
Out of the box, without installing anything else, you can use perfmon to gather performance metrics on the server and set up a server-side trace to capture the performance metrics...
"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
March 6, 2009 at 6:42 am
I'd say if most queries are coming through on the inv_no & month_no columns, then those are probably the best candidates for the clustered index. But, with 176 columns, you're...
"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
March 6, 2009 at 6:24 am
Definately use INFORMATION_SCHEMA system views is the way to go for stuff like this.
"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
March 6, 2009 at 6:20 am
Does the syntax of the view have WITH SCHEMABINDING in it? If so, simply remove that.
What is it you're trying 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
March 6, 2009 at 6:15 am
Just speaking for myself, I'm posting for three reasons. First, I've been helped in the past, so I try to help others. Second, this is a fantastic learning opportunity. When...
"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
March 6, 2009 at 6:08 am
Let me state up front that I am absolutely, adamantly, passionately against unionizing our industry in any way...
If the gun were held to my head and I was forced 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
March 6, 2009 at 5:51 am
RBarryYoung (3/6/2009)
Holy Moley! That does look like plagarism, doesn't it?
It is. It was lifted, whole hog, just, badly.
Phil Factor mentioned on a tweet yesterday that another MVP 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
March 6, 2009 at 5:43 am
rudy komacsar (3/5/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
March 6, 2009 at 5:35 am
Sorry, I was away. Did Gift Peddie's post help because I was going to suggest the code page or possibly the collation next.
"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
March 5, 2009 at 7:51 pm
t.walker (3/5/2009)
This is not a sarcastic point...
"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
March 5, 2009 at 7:36 pm
Lynn Pettis (3/5/2009)
Steve Jones - Editor (3/5/2009)
Supposedly this is an "MVP" 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
March 5, 2009 at 7:29 pm
Chris Morris (3/5/2009)
Hey Grant, your chum's back in town. I'm in the bleachers with a couple of beers.
Sorry, I was offline all day at our annual IS kickoff meeting. 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
March 5, 2009 at 7:21 pm
Viewing 15 posts - 18,091 through 18,105 (of 22,226 total)