Viewing 15 posts - 9,421 through 9,435 (of 22,224 total)
Beatrix Kiddo (10/23/2013)
Grant Fritchey (10/23/2013)
"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
October 23, 2013 at 7:14 am
100% Accidental.
I mainly took the job because it paid more. Flat out. When I was offered the job, I said no... until I was told the raise that went 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
October 23, 2013 at 6:27 am
Just remember that upward compatibility is seldom supported. Meaning, if you install SSMS for 2005, it probably won't connect to 2008, 2008R2, 2012 or 2014. Even if it does connect,...
"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
October 23, 2013 at 6:25 am
tabinsc (10/22/2013)
Thank you Steve for this article. This is something I need to do but haven't done yet. I guess writing the first one is the most difficult.
Nah,...
"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
October 22, 2013 at 8:18 am
Sean Pearce (10/22/2013)
Grant Fritchey (10/22/2013)
You could look at materialized or indexed views. These are actually a separate data store that you have to update to see data changes.
Indexed views do...
"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
October 22, 2013 at 8:16 am
Michael L John (10/22/2013)
Look at RDX also.
I was trying to think of that company. I did meet one of their DBAs last week. He seemed like a competent guy. That...
"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
October 22, 2013 at 8:12 am
As far as I know you can only do something like through ad hoc mechanisms or programming (PowerShell to the rescue).
"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
October 22, 2013 at 6:48 am
Using just SSMS and SSMS only, you can't run them at the same time. You can run them from two different windows, but there will be lag while you click...
"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
October 22, 2013 at 6:47 am
Only because instead of managing a single file now you're managing many. Sometimes it's the only way to get the job done, but it does add a wrinkle that makes...
"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
October 22, 2013 at 6:44 am
100% agreement. I usually tell people to write a post on backups. Yes, they've been done before. I think I must have 6-8 blog posts and at least that many...
"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
October 22, 2013 at 5:47 am
SQL Show (10/22/2013)
Full backup file is being overwritten(append) by Differential backup so file size increases.
No, not overwritten, added to. As Gail said, it's adding the differential to the full within...
"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
October 22, 2013 at 5:02 am
And you'll need each and every one of those files to restore the database.
"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
October 22, 2013 at 5:00 am
Just know that the restore operation completely replaces the existing database. It doesn't merge the two. If you have changes you've made to your copy of the database, they will...
"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
October 22, 2013 at 4:59 am
You could look at materialized or indexed views. These are actually a separate data store that you have to update to see data changes. But, they don't work well 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
October 22, 2013 at 4:54 am
My wife thinks what I do is the most boring thing in the world. But, sometimes, I still have to share with her, so, I explain all the concepts that...
"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
October 21, 2013 at 4:57 pm
Viewing 15 posts - 9,421 through 9,435 (of 22,224 total)