MS-SQL Server - Identity, Keys & Constraints, Schedule Job

Identity, Keys & Constraints, Schedule Job

Identity

https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql-identity-property?view=sql-server-ver16

Keys & Constraints

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

Schedule Jobs

https://learn.microsoft.com/en-us/sql/ssms/agent/schedule-a-job?view=sql-server-ver16

Additionally,

San Storage

https://learn.microsoft.com/en-us/answers/questions/742789/sql-server-database-with-san-storage

Getting monthly and weekly data from daily

https://learn.microsoft.com/en-us/answers/questions/852313/getting-monthly-and-weekly-data-from-daily-in-sql

Insert Statement - Turning off logging

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/78b8abda-54f3-4bbe-9157-b7627676cef8/insert-statement-turning-off-logging?forum=sqldatabaseengine

Performance Metrics

https://learn.microsoft.com/en-us/sql/relational-databases/performance/performance-monitoring-and-tuning-tools?view=sql-server-ver16

String Concatenation with Example

https://learn.microsoft.com/en-us/sql/t-sql/language-elements/string-concatenation-transact-sql?view=sql-server-ver16

There are around 50 SQL Server Background processes?

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/8d71f99a-654a-41dd-9449-553fe60ce39c/sql-server-background-process-details?forum=sqldatabaseengine

Database Engine events and errors

Any Query will be considered

T. Amit Vaid S.