#sql server dba queries

This is a collection of articles about SQL Server database administration that were formerly published on this blog. This is for quick reference.

This is a collection of articles about SQL Server database administration that were formerly published on this blog. This is for quick reference.   sys.objects “type” abbreviations and their meanings – SQL Server A system table or catalog table that stores “System Objects” is called sys.objects. Every user-defined, schema-scoped object that is created in a database is represented by a row,…