@pete: when you have an partitioned table, you can specify the "statistic_incremental" keyword on the create index statement (or the WITH INCREMENTAL on a CREATE STATISTICS). This allows you to create / update statistics on partition level (which will be later be merged into the "main statistic". Of course it may be hard (or a longer process) to implement it later on an existing large table
Hey Brent, great stuff as usual. Maybe for the next one you can get to the second part of the last question? --> "Also, is your advice still to have separate drives for dbf, logs, and tempdb even in a VM environment where the different 'drives' are partitions on a huge shared drive array?"
I think Morrise Van Quible was more asking about the extra size of having a second key in the index. My thinking is that is trivial unless there are millions of rows or if ColumnB is a long N/VARCHAR.
Sounds like the next port is Bodø where I grew up. A couple of good map apps for Norway is Norgeskart Outdoors and Navida. I prefer Navida in M-711 mode and not Open Streetmap (even if it worked well in Scotland).
![Seungmin "그렇게, 천천히, 우리(As we are)" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/kAzmhLHePqU/mqdefault.jpg)
@pete: when you have an partitioned table, you can specify the "statistic_incremental" keyword on the create index statement (or the WITH INCREMENTAL on a CREATE STATISTICS). This allows you to create / update statistics on partition level (which will be later be merged into the "main statistic". Of course it may be hard (or a longer process) to implement it later on an existing large table
Right, the challenge is that the main statistic, which is used for cardinality estimation, still only has 200 steps.
Hey Brent, great stuff as usual. Maybe for the next one you can get to the second part of the last question? --> "Also, is your advice still to have separate drives for dbf, logs, and tempdb even in a VM environment where the different 'drives' are partitions on a huge shared drive array?"
I think Morrise Van Quible was more asking about the extra size of having a second key in the index. My thinking is that is trivial unless there are millions of rows or if ColumnB is a long N/VARCHAR.
Nice background, Brent!
That is an awesome idea.
Do all your videos in this style 🙂it'll be double pleasure.
Glad you liked it! Check out my channel - there are tons of videos of me doing Office Hours all over the world. Cheers!
That policy sounds like a way to avoid or prevent paying for small expenses…
which policy?
Sounds like the next port is Bodø where I grew up.
A couple of good map apps for Norway is Norgeskart Outdoors and Navida. I prefer Navida in M-711 mode and not Open Streetmap (even if it worked well in Scotland).
We did indeed stop there!