Viewing 15 posts - 5,701 through 5,715 (of 39,754 total)
Shrinking a log or database only removes pages that are unused by the system.
If you are taking log backups, check the sizes. That's the level of activity that...
February 22, 2018 at 8:56 am
Use roles. In this case, I can't test, but I think you can track all activity by public. Every user is in public.
February 21, 2018 at 9:08 am
Maybe Biml can help - http://www.sqlservercentral.com/stairway/100550/
February 21, 2018 at 9:04 am
https://docs.microsoft.com/en-us/sql/integration-services/integration-services-error-and-message-reference
Says destination not available
February 21, 2018 at 9:03 am
February 21, 2018 at 8:54 am
Didn't mean to imply that containers don't support cloning, nor do I think I did. Containers supplied from MS are separate items, and each has separate data needs to be...
February 20, 2018 at 11:58 am
February 20, 2018 at 6:13 am
Apologies for the explanation. That is updated.
For the result set answer, expanded to note the answer is a multi-line result set.
Technically, @@options returns an integer. You can...
February 20, 2018 at 6:09 am
Thanks. I find XE cumbersome, but I am trying to fix that, or at least learn how to work with it better.
February 16, 2018 at 1:49 pm
XE is a tracing system that can capture all activity occurring in SQL Server. This replaces SQL Trace/Profiler, which is a more heavyweight way of gathering activity. SQL Trace also...
February 16, 2018 at 8:54 am
I bet it was. Lots of work being done at MS on GDPR compliance.
February 16, 2018 at 8:48 am
February 15, 2018 at 10:01 am
Go for it, Angel. So far haven't seen a good basic for the latest version.
February 14, 2018 at 11:18 am
February 14, 2018 at 11:16 am
Viewing 15 posts - 5,701 through 5,715 (of 39,754 total)