Viewing 15 posts - 16,051 through 16,065 (of 22,226 total)
If the database is from a more recent hotfix or service pack you need to apply that hotfix or service pack to your machine. Once done you should be able...
"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
December 14, 2009 at 8:58 am
Absolutely follow BitBucket's advice.
Just don't run the Profiler GUI directly against any of your production systems. Only use the server side trace (TSQL scripts) against production systems.
"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
December 14, 2009 at 8:46 am
You have to use source control as the basis upon which to build the database. Don't edit procedures on the database, edit the scripts and then apply these to 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
December 14, 2009 at 8:38 am
I'm with Lynn too. It's either stats or parameter sniffing or both.
To get the execution plans, you can query the dynamic management objects to pull it out of cache directly,...
"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
December 14, 2009 at 8:35 am
I've seen major applications done both ways and the single, purpose built table style of design just flat out works better. It's easier to maintain the structures, there are fewer...
"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
December 14, 2009 at 8:30 am
We've been experiencing the same thing on one database on our server. I've been running in circles trying to find anything wrong on the database side of things. Finally 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
December 14, 2009 at 8:13 am
RBarryYoung (12/13/2009)
Grant Fritchey (12/13/2009)
RBarryYoung (12/12/2009)
Oops!Congrats Barry.
I can't decide if "oops" is incredibly sad or absolutely appropriate for the 10,000th post.
Actually its the word most often said immediately before someone posts...
"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
December 13, 2009 at 9:08 am
RBarryYoung (12/12/2009)
Oops!
Congrats Barry.
I can't decide if "oops" is incredibly sad or absolutely appropriate for the 10,000th post.
"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
December 13, 2009 at 6:40 am
GabyYYZ (12/11/2009)
Lynn Pettis (12/11/2009)
GabyYYZ (12/11/2009)
Lynn Pettis (12/11/2009)
Sometimes, you just have to question people.
Was the original post a request or a command? (or is it a followup to another thread...
"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
December 11, 2009 at 1:35 pm
Nah, none of this honor stuff. 10,000 should be a total scramble. Biting, kicking, scratching. In honor of the 10,000.
"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
December 11, 2009 at 12:41 pm
sqllearner-339367 (12/11/2009)
Grant,Actual estimated plan attached. (Wake up call to update my skills)
Ta
Looking at the plan, you're still getting scans. Is this taken after you added the index that improved performance...
"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
December 11, 2009 at 6:37 am
sqllearner-339367 (12/11/2009)
Grant,Actual estimated plan attached. (Wake up call to update my skills)
Ta
Actual "estimated" plan.... Is that like honest politician? Kidding.
Plans are either "estimated" meaning they're the plan generated by 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
December 11, 2009 at 6:29 am
I have yet to find a need for writing a CLR package of any kind, so I'm not using CLR directly.
However, I do use CLR quite a lot. We have...
"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
December 11, 2009 at 5:51 am
sqllearner-339367 (12/11/2009)
Hi Grant,Neither Ctrl + M or clicking Include Actual Execution plan is not bringing the execution plan.
Not suer why this is happening.
Ta
You have to then execute the query. 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
December 11, 2009 at 5:34 am
No, but the use of fonts sure is.
"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
December 10, 2009 at 1:15 pm
Viewing 15 posts - 16,051 through 16,065 (of 22,226 total)