This is a simple test or assignment to see how comfortable someone is using SQL at the beginner to advanced level. Exercises of this nature
Category: SQL Server
SQL Server Administration, Development and Maintenance
SQL Server Interview Questions All in One
This is a collection of previously published articles on this site about SQL Server interview questions and answers. This is for quick reference.
SQL Server Database Administration
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
Sys.Procedures in SQL Server
The subset of sys.objects with the object types = P, X, RF, and PC can be found in the object catalog view sys.procedures. P =
List of indexes with Index Type – SQL Server
The system catalog views sys.indexes and sys.index_columns make it easy to get a list of all indexes and index columns in a database. You may
Big Data & SQL 