Viewing 15 posts - 7,921 through 7,935 (of 22,232 total)
tcronin 95651 (6/24/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 24, 2014 at 8:54 pm
WHOOP!
"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:31 pm
I wouldn't want to simultaneously build a cluster while upgrading a server with databases in place. Way too many things can go wrong there. I'd prefer to build a cluster...
"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 7:51 am
If the database is going to grow to 10gb once every 10 months, why not just leave it at 10gb. The shrinking, or not shrinking, has nothing to do with...
"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 6:27 am
By archived, do you mean backed up? If so, then you can query the msdb database to see the backup history[/url]. If you mean some other process where data 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
June 24, 2014 at 5:24 am
On a database that small... I wouldn't sweat it, but if you are worried, take more frequent log backups. That will reclaim space faster.
"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:22 am
Don't do that.
If your log it growing over and over again, you need to determine why it's growing. Deal with that cause. Set the log to an appropriate size. Make...
"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:20 am
Rebuilding the indexes removes wasted space by moving rows that are distributed across a lot of empty space and compacting them into individual pages. This allows for more compression. Regular...
"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:20 am
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
Viewing 15 posts - 7,921 through 7,935 (of 22,232 total)