Viewing 15 posts - 9,421 through 9,435 (of 22,219 total)
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
TWH (10/16/2013)
How do you keep current with SQL Server?
Lots and lots and lots of experimentation, reading and listening. I experiment with technologies I don't understand or need to learn 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
October 21, 2013 at 4:55 pm
One thing you can do is to use Red Gate SQL Prompt to format the query, whether it gets saved correctly or not.
"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:48 pm
There are a number of things that could cause differences. I'd focus first on the execution plans for each query. Are they the same? If not, your issues are narrowed...
"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:47 pm
It sounds like a permissions issue. Do you connect to the SQL Server instance with a different login than the one that is running Visual Studio?
You may need to create...
"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:44 pm
I'm pretty sure you can use one of the file splitting utilities to break them apart and put them back together even though they're encrypted. Other than that, you could...
"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:34 pm
Viewing 15 posts - 9,421 through 9,435 (of 22,219 total)