Viewing 15 posts - 7,006 through 7,020 (of 22,226 total)
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
I'm just subscribed to all of it forever. Too much work to try to clean it out. If any one thread gets stupid (this one for example), I'll remove 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
January 6, 2015 at 11:16 am
Turn that around. You should only supply them a backup that has clean data. What's to keep a bad person from just taking the backup offsite and doing what they...
"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:14 am
You can look at sys.dm_db_index_usage_stats to see how, or if, the index is being accessed. Just note that the statistics are reset if the server is restarted, or 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
January 6, 2015 at 10:57 am
SQLRNNR (1/6/2015)
KenpoDBA (1/5/2015)
I think you guys have all been punked.Wow, look at that picture from sooo long ago.
Yeah, he was almost pretty once. Almost.
"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 9:35 am
There's no way I know of to disable menu options inside of SQL Server Management Studio. The tool is what it is. Permissions given within a server instance will allow...
"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 9:16 am
Nah, the basics of backup are, well, basic. You'll be fine. Restore gets marginally more complicated. But then it can get crazy as you start to add wrinkles. Don't sweat...
"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 7:25 am
IncidentalProgrammer (1/6/2015)
"The full backups would be a guaranteed recovery...
"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 6:59 am
Let's try two things. First, qualify all the column names. You've created aliases, at, am, put those in front of the columns where appropriate so that all the columns are...
"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 5:08 am
Viewing 15 posts - 7,006 through 7,020 (of 22,226 total)