MS- SQL Server - Tail-Log Backup

Tail-Log Backup

Tail-Log Backup

https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/tail-log-backups-sql-server?view=sql-server-ver16

Lots of Sleeping Connections

https://social.msdn.microsoft.com/Forums/en-US/eda510f3-f1c4-43a0-97ef-f1cf5272e639/too-many-sleeping-session-in-sql-server?forum=sqldatabaseengine

Machine Learning

https://learn.microsoft.com/en-us/sql/machine-learning/sql-server-machine-learning-services?view=sql-server-ver16

Checkpoint

https://learn.microsoft.com/en-us/sql/relational-databases/logs/database-checkpoints-sql-server?view=sql-server-ver16

Hyper Threaded

https://support.microsoft.com/en-us/topic/kb322385-sql-server-support-in-a-hyper-threaded-environment-a2a23c22-2400-a708-b9e3-754af6e2cd28

Uniform and Mixed Extents, GAM & SGAM

https://techcommunity.microsoft.com/t5/sql-server-support-blog/sql-server-extents-pfs-gam-sgam-and-iam-and-related-corruptions/ba-p/1606011

Partial Restore

https://learn.microsoft.com/en-us/answers/questions/589161/restore-with-norecovery

Shared Memory

https://learn.microsoft.com/en-us/sql/tools/configuration-manager/shared-memory-properties?view=sql-server-ver16

Count

https://learn.microsoft.com/en-us/sql/t-sql/functions/count-transact-sql?view=sql-server-ver16

Lower

https://learn.microsoft.com/en-us/sql/t-sql/functions/lower-transact-sql?view=sql-server-ver16

OR

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

Where Clause

https://learn.microsoft.com/en-us/sql/t-sql/queries/where-transact-sql?view=sql-server-ver16

Add Column

https://learn.microsoft.com/en-us/sql/relational-databases/tables/add-columns-to-a-table-database-engine?view=sql-server-ver16

Additionally,

Error Severities

https://learn.microsoft.com/en-us/sql/relational-databases/errors-events/database-engine-error-severities?view=sql-server-ver16

Best Regards

T. Amit Vaid S.