Question : After configuring XE on November 23, 2020 to capture some errors I could count 2,163,665 occurrences of the […]
Tag: enterprise-edition
Can partitioning help speed up inserts on a very large table?
Question : Some background: SQL 2012 Enterprise OLTP table currently at 1B records records increase 5-10M per day SAN lun […]
SQL Server 2016 Enterprise poor performance
Question : Sorry to be long, but I want to give you as much information as possible so that might […]
Modifying Schema on secondary replica
Question : I am looking for a solution for a secondary replica change. I have a vendor database that uses […]
Upgrade/Transition Path from MySQL Community 5.6.31 to Enterprise
Question : Full disclosure. I have never upgraded a database. I have a MySQL Community that is not the latest […]
Decision concerning RAM limit
Question : What steps would you do to be sure that STANDARD edition with its 128GB RAM limit is enough […]
Can SQL Server R Services be enabled on a readable secondary?
Question : To avoid excess load on the primary SQL Server, I’d like to install and enable R Services on […]
Downgrade SQL Server Enterprise Edition to SQL Server Standard Edition
Question : There is a requirement in our project where they want to evaluate if it is possible to downgrade […]
SQL Server 2016 Enterprise poor performance
Question : Sorry to be long, but I want to give you as much information as possible so that might […]
Using SPID in DB Tables (instead of Table Variable)
Question : Transactional database used for booking things… Our vendor was asked to replace #temptables with @tablevariables (because of heavy […]
- 1
- 2