Try our new research platform with insights from 80,000+ expert users

Badges

35 Points
2 Years

User Activity

Over 2 years ago
@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…
Over 2 years ago
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…
Over 2 years ago
@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.
Over 2 years ago
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…
Over 2 years ago
Over 2 years ago
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…

Reviews

Answers

Over 2 years ago
BI (Business Intelligence) Tools
Over 2 years ago
Relational Databases Tools

About me

I have been in IT 40+ years and BI 30+ years.