Viewing 15 posts - 7,906 through 7,920 (of 22,219 total)
Hard to completely understand what you're going for, but it actually sounds like a many to many relationship, not one to many. In this case, I'd have TableA which 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 25, 2014 at 3:54 am
As much as you can, I'd try to keep any queries against the SQL database up in the Azure cloud. Any, regardless of if you write them or you use...
"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:55 pm
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
Viewing 15 posts - 7,906 through 7,920 (of 22,219 total)