Viewing 15 posts - 16,576 through 16,590 (of 22,219 total)
crainlee2 (9/5/2009)
I don't think so. I'm running DTA as a server and dba admin with authority to do anything so I don't think that's it but thanks for asking about...
"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 6, 2009 at 5:48 am
And just to add to that a bit, shrinking the database is not a method for optimizing performance. It's a little shocking that a vendor is recommending this as 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
September 5, 2009 at 6:17 am
Excellent post sudhanva. Very well summarized. I agree, there are few, if any situations where stored procedures should not be used.
Unfortunately, I need to point out one issue:
sudhanva (9/5/2009)
Not 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
September 5, 2009 at 6:12 am
Every time I use the DTA I'm impressed by what it misses. Yes, you could try making adjustments to the template and you will get more suggestions, not necessarily good...
"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 5, 2009 at 5:58 am
AllenMWhite (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 11:22 am
AllenMWhite (9/4/2009)
http://blogs.msdn.com/mwories/archive/2008/06/14/SQL2008_5F00_Powershell.aspx
Copy out the script in that post. Once you've executed that, you've got the SQL 2008 dlls and...
"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 11:18 am
AllenMWhite (9/4/2009)
You can install PowerShell 1.0 on any Windows...
"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 11:03 am
Hey Allen. Great presentation the other day.
So, what about just installing Powershell on a 2000/2005 server, or what if the 2000/2005 is running on a 2008 Server machine? Can 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
September 4, 2009 at 10:46 am
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
Viewing 15 posts - 16,576 through 16,590 (of 22,219 total)