Viewing 15 posts - 12,841 through 12,855 (of 59,062 total)
I appreciate that (and hopefully this isn't coming off as violently defensive or anything...
February 19, 2018 at 8:15 pm
February 19, 2018 at 8:07 pm
And I'm still having a really hard time understanding why someone would put a...
February 19, 2018 at 7:27 pm
What do you mean by "pre-compacted"? If you mean you did a shrink-file or shrink-database, then don't bother because just updating stats on tables that have been logically inverted by...
February 19, 2018 at 7:08 pm
SQL!$@w$0ME - Monday, February 19, 2018 4:19 PMOracle box has 99.99% availability. Thanks
K. Are you looking to copy all changes to a...
February 19, 2018 at 5:29 pm
February 19, 2018 at 2:23 pm
I'm not with Jeff on the "well designed triggers". Well designed triggers exist...
February 19, 2018 at 1:50 pm
February 19, 2018 at 1:18 pm
February 19, 2018 at 12:56 pm
As for avoiding triggers, I think that too many people make the recommendation to...
February 19, 2018 at 7:16 am
I also would NOT make a view of this. Rather, I'd create an iTVF as a bit of a "parameterized view" so that you don't have to change the actual...
February 19, 2018 at 5:37 am
I did a search of "Materialized Views Oracle" and got quite a bit of information about it. It does seem that materialized views in Oracle can do quite a bit...
February 19, 2018 at 5:34 am
Ah... one more thing. If anyone suggests the use of "portable/universal CLR triggers", send them from the room because they have no clue what a horrible impact that will have...
February 18, 2018 at 8:25 pm
I'll also add that you need to know how long you need to keep the audit data online, on disk, and on tape. If you can ever delete audit data,...
February 18, 2018 at 8:17 pm
Viewing 15 posts - 12,841 through 12,855 (of 59,062 total)