Viewing 15 posts - 16,591 through 16,605 (of 22,226 total)
Daniel Auger (9/4/2009)
http://nhprof.com/Learn/Alert?name=SelectNPlusOne
EDIT: I will add that Select N + 1 is not a problem that directly stems from using an ORM...
"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
September 4, 2009 at 10:32 am
Daniel Auger (9/4/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
September 4, 2009 at 9:40 am
Ah, you know what it might be? One guy in my office (and he's the only one for some reason), has a lot problems with files getting saved with 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
September 4, 2009 at 9:36 am
Hmmm... No. I haven't seen that one. Is it possible that there's a difference in the server or database collation? That might lead to something 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
September 4, 2009 at 9:05 am
So this section means that you can not run the Powershell extension on a 2000/2005 instance?
You must use the SQL Server 2008 client components to run SQL Server features for...
"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
September 4, 2009 at 8:40 am
Hey Jack,
I haven't tried this on 2005 yet, but I assume you've got to do a seperate install of PowerShell, then the SQL Server extensions. After that, you should be...
"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
September 4, 2009 at 7:35 am
Are you running the DTA against the production server? I hope not. If you're running it against another machine, you may need to validate that it has all the exact...
"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
September 4, 2009 at 7:29 am
It looks like something in the TSQL, not the network. Can you post the whole query?
"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
September 4, 2009 at 7:24 am
luckysql.kinda (9/3/2009)
DBCC FREEPROCCACHE
DBCC FREESESSIONCACHE
Run your query and inform us how much time does this take? Also use task manager and job monitor to see...
"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
September 4, 2009 at 3:59 am
I'd suggest capturing the execution plans to see what is occurring.
However, it sounds like the data was being moved into cache. You can pretty frequently see a query run much...
"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
September 3, 2009 at 4:25 pm
GilaMonster (9/3/2009)
CirquedeSQLeil (9/3/2009)
does that mean he has learned how to research the issue and troubleshoot?Based on this I have to say 'No'
Could it be a language issue? Is BOL translated...
"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
September 3, 2009 at 4:17 pm
Elliott W (9/3/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
September 3, 2009 at 4:10 pm
sturner (9/3/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
September 3, 2009 at 1:21 pm
Running a server side trace is the best thing you do for yourself. Capture the queries as they're made and see which ones run slow and when. Read Gails articles...
"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
September 3, 2009 at 12:05 pm
Combining views is not dissimiler to joining views or nesting views. It all leads to poor choices by the optimizer due to the complexity of the plan when the optimizer...
"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
September 3, 2009 at 12:00 pm
Viewing 15 posts - 16,591 through 16,605 (of 22,226 total)