MS-SQL Server - Keys & Constraints & Shrink a File

Keys & Constraints & Shrink a File

Keys & Constraints
https://learn.microsoft.com/en-us/sql/relational-databases/tables/primary-and-foreign-key-constraints?view=sql-server-ver16

Shrink a File
https://learn.microsoft.com/en-us/sql/relational-databases/databases/shrink-a-file?view=sql-server-ver16

Inbound & Outbound Rules
https://learn.microsoft.com/en-us/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-server-access?view=sql-server-ver16

Named Instance
https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/database-engine-instances-sql-server?view=sql-server-ver16

RAM Usage High
https://community.spiceworks.com/topic/2227788-microsoft-sql-server-high-memory-usage-constant-help#:~:text=SQL%20Server%20will%20use%20as,total%20memory%2C%20whichever%20is%20higher.

Get Next 7 Days Birthday Data in SQL
https://learn.microsoft.com/en-us/answers/questions/973083/get-next-7-days-birthday-data-in-sql

Lesson 2: Create and Apply a Naming Standards Policy
https://learn.microsoft.com/en-us/sql/relational-databases/policy-based-management/lesson-2-create-and-apply-a-naming-standards-policy?view=sql-server-ver16

Imp. Errors.

Any query will be considered.

T. Amit Vaid S.