Pages

Wednesday, April 12, 2023

MS-SQL Server - A PK Mandatory

A PK Mandatory


Transactional replication requires a primary key constraint on each table required to get replicated/published.

https://learn.microsoft.com/en-us/sql/relational-databases/replication/administration/frequently-asked-questions-for-replication-administrators?view=sql-server-ver16

Monitoring Distribution Database


Additionally,


Char, Varchar DataTypes & Group by Clause


Volume Maintenance Task

https://learn.microsoft.com/en-us/windows/security/threat-protection/security-policy-settings/perform-volume-maintenance-tasks

Some Important Waittypes

CXPACKET
BROKER_EVENTHANDLER
ASYNC_NETWORK_IO
AUDIT_ON_DEMAND_TARGET_LOCK

Best Regards

T. Amit Vaid S.

No comments:

Post a Comment