Skip to main content

Questions tagged [slq-server-2019]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
2 answers
258 views

Replace primary key with unique constraint and other clustered index to improve query performance without doubling table size

I've got a SQL Server 2019 with a large fact table (currently ~100 million rows but will most likely be >1 billion within a year and continue to increase for a long time). The primary objective is ...
Martin Riddar's user avatar
-1 votes
1 answer
27 views

Database in recovery mode

My database is entered in recovery mode due to power loss while executing query! I have tried a lot of queries but i am unable to resolve that problem
Mohammed Turi's user avatar
-1 votes
1 answer
667 views

sp_rename column and CDC

I have a table in a SQL Server 2019 instance which is being CDC tracked. However when I want to rename a column it failes with the error: Cannot alter column 'Columnn2' because it is 'REPLICATED. I ...
Peter's user avatar
  • 2,362
1 vote
1 answer
409 views

SQL Server dependency on "CNG Key Isolation"

A few days ago, I freshly installed SQL Server 2019 Evaluation Edition using the media downloaded from the Microsoft's website, and subsequently noticed that a Windows service named "CNG Key ...
RGO's user avatar
  • 423