Viewing 15 posts - 18,376 through 18,390 (of 22,219 total)
Lynn Pettis (2/13/2009)
No. Running the query above prior to creating the clustered index will have no affect at all on the create index statement.
Actually won't it slow everything down?...
"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
February 13, 2009 at 8:41 am
sam (2/13/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
February 13, 2009 at 8:34 am
GilaMonster (2/13/2009)
The terms estimated and actual for plans are actually a bit of a misnomer....
"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
February 13, 2009 at 8:30 am
Grant Fritchey (2/13/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
February 13, 2009 at 8:27 am
Yeah, you're probably running into schema issues. If the schema defining the object is anything other than the default schema for the connection, you can't simply call the proc.
"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
February 13, 2009 at 7:52 am
Brandie Tarvin (2/13/2009)
I've heard those too. I certainly will. @=)Hmm. I also need to write another article for the site. I wonder what I shall compose...
I owe Steve an article...
"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
February 13, 2009 at 7:49 am
Again, I'm just getting started supporting it. However, I found some fun stuff in nHibernate that is going to seriously impact our performance over time. For example, check out my...
"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
February 13, 2009 at 7:47 am
Yeah, that's how you get the actively executing plan. It must show the estimated plan while executing... I can't find documentation that says it would show the estimated plan though......
"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
February 13, 2009 at 7:43 am
Ken Gaul (2/13/2009)
That's where I got the bad plan in the first place I'm afraid. I was a little surprised to see it was an estimated plan though.
Really? An estimated...
"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
February 13, 2009 at 7:12 am
Welcome to blogging. I've heard rumors that syndication may be starting up around here. Be sure to volunteer when they get it going.
"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
February 13, 2009 at 7:04 am
How about querying sys.dm_exec_query_plans and pull it out of there? That would be the best way to go for something of this nature.
"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
February 13, 2009 at 6:31 am
That's not a standard error message that I'm aware of. What's the context in which you're recieving 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
February 13, 2009 at 6:10 am
The main problem is to join two tables from two servers, you have to move the entire contents of one of the tables to the other server. So as you...
"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
February 13, 2009 at 6:07 am
It's hard to not to say something stupid without the execution plan (and all too easy then). The one thing that bothers me about the code so far is 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
February 13, 2009 at 6:00 am
You can, but why not use the CTE?
"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
February 13, 2009 at 5:53 am
Viewing 15 posts - 18,376 through 18,390 (of 22,219 total)