Viewing 15 posts - 16 through 30 (of 230 total)
June 12, 2018 at 7:21 am
May 22, 2018 at 12:21 pm
May 9, 2018 at 2:11 pm
February 19, 2018 at 9:46 am
Thanks for all the info. In this scenario the user (at a minimum) is supposed to apply filters on year, month, and customer (an orders history table with 100 million...
February 19, 2018 at 8:09 am
February 16, 2018 at 1:52 pm
Oh yes, I should clarify: Load is not a concern, that's all been addressed and resolved. This is reporting off a read only replica. (Well a HA Always on Availability...
February 16, 2018 at 10:10 am
Replace all composite keys with a single column key for reporting purposes.
We run lots of Ad Hoc reports against the tables and end users having to join on...
January 5, 2018 at 11:52 am
Ah ok that all makes a lot of sense (all the replies) thanks!!
October 4, 2017 at 9:52 am
September 26, 2017 at 1:55 pm
September 26, 2017 at 8:17 am
Ah good points on stats, I didn't consider how it could deviate based off that.
However, the good news is that the stats appear to be up to date...
September 5, 2017 at 12:07 pm
Thanks that is most helpful.
Wanted to make sure I didn't miss some simple option or way around it, etc...
Same for VIEWS I assume, and a VIEW can't do Execute As...
December 19, 2016 at 10:03 am
Perry Whittle (2/18/2016)
Are you testing other more realistic DR scenarios too, don't...
February 18, 2016 at 1:04 pm
Viewing 15 posts - 16 through 30 (of 230 total)