USB Tethering and how to make it work
WiFi Calling feature does not work when Bluetooth is enabled and a headset is currently not connecting to the phone.
We presented the solution to the business owners, with multiple sample reports generated by SSMS, Regular Pivot Tables and PowerPivot for Excel. We sliced and diced at the client level, server level and the results were coming back pretty fast. They were extremely happy as they just found a way to slice “everything by everything”. I even heard the statement ”This will be the company’s biggest asset”.
Based on what we have experienced, it appears that its more efficient to just immediately insert into a compressed table, with a partitioned clustered index.
DBA skills are not just a nice-to-have. It is a requirement. Do it right the first time and avoid the hassle of fixing in the future.