All Questions
Tagged with standard-edition sql-server-2019
9 questions
4
votes
1
answer
127
views
Why does adding an empty columnstore index to my tables consistently make execution plans ignore bitmaps?
Problem
I am using a Standard Edition SQL Server 2019 box. Given the edition, compatibility levels should not be relevant (the level-dependent batch mode features are disallowed on Standard). On this ...
- 90.3k
0
votes
1
answer
197
views
SQL Server Standard and Enterprise editions in AlwaysOn Availability Groups
Can two different versions of SQL Servers participate in AlwaysOn Availability Groups?
I am specifically talking about SQL Server 2019 Standard and SQL Server 2019 Enterprise.
- 39.5k
-1
votes
1
answer
128
views
How is basic availability group able to auto failover without a cluster?
I have recently learnt that the SQL server standard edition's basic availability group doesn't require a windows cluster.
Basic AG is considered equivalant to the deprecated mirroring technology. Like ...
- 47.6k
0
votes
1
answer
90
views
What happens when you try to use more than 32 GB of memory-optimized data in a database on Standard Edition?
In SQL Server 2019, you cannot put more than 32 GB of memory-optimized data in a database on Standard Edition. What happens if you try anyway?
I'd try it myself, but I don't want to risk discovering ...
- 47.6k
12
votes
1
answer
817
views
Is there a reliable way to check if a trigger being fired was the result of a DML action from another *specific* trigger?
Is there any way to tell from within a trigger, when it gets fired, that it is being fired as the result of a DML action that occurred within another specific trigger?
Any chance any information about ...
- 14.5k
7
votes
4
answers
1k
views
Is my queue table implementation race condition safe?
Hello people smarter than me! I've created a sort-of-a-queue table system, but it seems too simple to be safe from race conditions. Am I missing something or is the following race condition safe?
The ...
- 26.9k
3
votes
2
answers
299
views
How to sum up the distinct Total Time of an Event ignoring duplicate overlaps in Times?
I have the following EventTimes table:
DROP TABLE IF EXISTS dbo.EventTimes;
CREATE TABLE dbo.EventTimes
(
EventTimeKeyId INT IDENTITY(1,1) PRIMARY KEY,
EventId INT NOT NULL,
StartTime TIME NOT ...
- 328
-1
votes
1
answer
180
views
When DML and DDL changes occur on a Temporal Table do the correlating changes in the History table get logged in the Transaction Log as well?
When DML and DDL queries are executed against a Temporal Table, those changes are appropriately propagated to the correlating History table. E.g. an UPDATE to the Temporal Table results in a new ...
- 29.8k
0
votes
1
answer
1k
views
What happens to a SQL Server 2019 Standard instance with an Annual Subscription Licence when it expires?
We have 3 production SQL Server 2019 standard instances which we have licenced through a third party supplier on an annual subscription basis. In our use case this works out cheaper if you only ...
- 47.6k