Question : I’d like some input on an issue I’m having. We have a section of code that we repeat […]
Tag: enterprise-edition
SQL Server Editions: Backup restore of Enterprise Edition 2014 on Standard Edition 2017
Question : I know, this kind of question has already been answered some times but I don’t find some current […]
Online index rebuild higher fragmentation on intermediate level
Question : I need to rebuild some big indexes and I’m doing some tests with the various options (sort_in_tempdb, maxdop, […]
Nonclustered Index Rebuild Online on Heap Table
Question : Recently read that rebuilding a heap online in SQL Server Enterprise is single threaded and does not go […]
SQL Server 2017 Enterprise vs Standard – Online Indexing and Online Schema Change
Question : I read through Microsoft’s “Editions and supported features of SQL Server 2017” doc to compare the feature differences […]
Database Blocking, kill the session which is responsible after 5 minutes
Question : I have been struggling with database blocking at my database server from last so many months. Have tried […]
How can I measure the impact of queries with errors being rejected by SQL Server?
Question : After configuring XE on November 23, 2020 to capture some errors I could count 2,163,665 occurrences of the […]
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 […]