Viewing 15 posts - 6,991 through 7,005 (of 22,212 total)
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...
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...
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...
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.
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...
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...
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...
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...
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...
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...
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...
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.
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...
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...
January 6, 2015 at 7:25 am
IncidentalProgrammer (1/6/2015)
"The full backups would be a guaranteed recovery...
January 6, 2015 at 6:59 am
Viewing 15 posts - 6,991 through 7,005 (of 22,212 total)