Viewing 15 posts - 7,921 through 7,935 (of 22,224 total)
As far as setting up the servers, that's what you're going to have to do. When you say "start the upgrade process" that's the question. Since you're installing new servers,...
"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
June 24, 2014 at 5:16 am
There's nothing you can run specifically to reload queries into cache. You running the app is doing that work for you. In short, this command is not something that should...
"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
June 24, 2014 at 5:14 am
Koen Verbeeck (6/24/2014)
Grant Fritchey (6/23/2014)
Koen Verbeeck (6/23/2014)
😎 13000th point 😎Also went over 9000 forum posts a while back. :w00t:
Nicely done.
Yes, I'm getting closer 😉
Well, not quite so close now.
"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
June 24, 2014 at 5:10 am
Koen Verbeeck (6/23/2014)
😎 13000th point 😎Also went over 9000 forum posts a while back. :w00t:
Nicely done.
"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
June 23, 2014 at 4:23 pm
Either the file is locked, or the user you're attempting to run the DTA with doesn't have access to the file location.
"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
June 23, 2014 at 8:28 am
Just trying to paste this into a query window to get a good view on what you're doing and I'm getting syntax errors. It looks like some of the code...
"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
June 23, 2014 at 7:25 am
Never go back to the old job. All the reasons you left are still there. It's the same arguments for never taking a counter-offer. If all you needed was more...
"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
June 23, 2014 at 7:16 am
From the sounds of it, there's senior level work in the organization, you just have to position yourself to be the one doing it. I've had these kinds of issues...
"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
June 23, 2014 at 6:17 am
It's what Koen says, you can train people on any topic you want, pretty much any way you want. What you can't do is post or teach information from 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
June 23, 2014 at 6:11 am
Please, not NOLOCK. That just makes it possible to get bad data.
Without seeing the query and the query plan, it's impossible to say for certain. It's entirely possible that 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
June 23, 2014 at 6:06 am
Why is my transaction log full?[/url]
"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
June 23, 2014 at 6:02 am
Indexed views could help.
If you create the table, which is just a matter of creating the table using the CREATE TABLE T-SQL syntax, you will then have to load 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
June 23, 2014 at 5:56 am
Yeah, it sounds like you might be trying to put 2008R2 on 2008 or vice versa. Double check your installation version. You can validate it against information on this web...
"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
June 23, 2014 at 5:54 am
Good luck!
"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
June 21, 2014 at 9:42 am
anoop.mig29 (6/21/2014)
Grant Fritchey (6/19/2014)
"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
June 21, 2014 at 9:36 am
Viewing 15 posts - 7,921 through 7,935 (of 22,224 total)