@Tim Lenz Hi Tim, yes. I give the same advice for data warehousing on SE. We suggest people check out manual partitioning on SE to get about 90% of the performance of EE for 30% (or less) of the cost. We have found that we can get very decent performance from manual…

Hi Evgeny Without being a "downer", what we are going to see is more of what we have seen for 25 years.  Our colleagues at BI vendors are pushing "features and functions" with precious little focus on business benefit of the users of these tools.  We are going to market…

@Lional Angelo "SQL pricing is slightly high compared to where it was before." In 2019 SE went up and EE came down quite a bit for the purchase price option. I am guessing you are referring to the cost of SE.

Hi Miriam,just for the data warehousing side. My advice for people wanting to use SQL Server for data warehousing is to consider manual partitioning on SE vs database supported partitioning on SE. SE lists for USD3,700 per core and EE lists for USD14,000 per core. The…

Oh... a chance to say what would be better in SQL Server? This is Data warehouse-related only.1. Have more than 1 column as the partitioning column. We implement partitioning manually to be able to get 90% of the EE performance on SE because SE is so much cheaper.2. Have…