Viewing 15 posts - 6,991 through 7,005 (of 22,219 total)
Steve Jones - SSC Editor (1/7/2015)
SQLRNNR (1/7/2015)
Stefan Krzywicki (1/7/2015)
Steve Jones - SSC Editor (1/7/2015)
Ahhh, the cloud... http://www.computerworld.com/article/2865802/verizon-warns-enterprise-cloud-users-of-48-hour-shutdown.html
Wow, that's a complete disaster. I wouldn't just be "downloading data to make sure...
"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
January 7, 2015 at 11:57 am
I'm not familiar with the Solarwinds tools, but I'd think there might be some way to do it with them.
However, if I were doing this with the native tools, I'd...
"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
January 7, 2015 at 11:53 am
Running a RESTORE WITH VERIFY_ONLY, which is what the backup validation does, shouldn't interfere with log shipping or anything else on your server.
"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
January 7, 2015 at 11:34 am
Take a look at the execution plan for the query. See how it's being resolved. That will tell you if it's doing a scan or a seek for the UPDATE....
"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
January 7, 2015 at 9:03 am
GilaMonster (1/7/2015)
Grant Fritchey (1/7/2015)
Further, your databases may have to be distributed across multiple servers through sharding in order to ensure additional redundancy.
In multiple data centers, with redundant network connections...
"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
January 7, 2015 at 7:10 am
This is not something I've attempted myself, but there is documentation on how to set it up available on MSDN. That includes a step by step process along with 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
January 7, 2015 at 7:05 am
The only way to achieve anything like this is a combination of code and database design, regardless of your data platform. You're going to have to have an application server...
"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
January 7, 2015 at 6:58 am
muralikrishna2489 (1/7/2015)
I dont know how to put a execution plan in SQL. I have created in Doc and attached.
Regarding UNION ALL, I was advised that Since both Changes 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
January 7, 2015 at 4:07 am
I have not set up a failover cluster using an Azure VM. I have set up an Availability Group and put individual databases into it. It does support the full...
"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
January 7, 2015 at 4:02 am
One other point, I'm not sure what industry you're working in, but many, especially healthcare, now have criminal penalties if you expose personal data to people without permission or a...
"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
January 6, 2015 at 4:50 pm
Yeah, Sean makes an excellent point.
Remember, you're not building a backup plan. You're building a recovery plan.
"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
January 6, 2015 at 4:43 pm
If you want to use the dynamic management views to look for currently executing queries or procedures, instead of going off of sys.dm_exec_procedure_stats (or sys.dm_exec_query_stats), I'd suggest using sys.dm_exec_requests. That's...
"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
January 6, 2015 at 3:48 pm
The view is a good approach.
You could also look to adding an additional join to a table that lists the data you want (or don't want, I'd probably go...
"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
January 6, 2015 at 3:46 pm
What's the concern with taking more frequent full backups? Or maybe differentials?
The thing is, it's not just a question of backing up, it's also a question of restoring. When you...
"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
January 6, 2015 at 3:43 pm
Koen Verbeeck (1/6/2015)
Grant Fritchey (1/6/2015)
If any one thread gets stupid (this one for example)Blasphemy! 😀
Best wishes by the way.
And a Happy New Year to you as well. Seriously hoping to...
"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
January 6, 2015 at 11:52 am
Viewing 15 posts - 6,991 through 7,005 (of 22,219 total)