Microsoft SQL Server

Metadata

View the service name and account

SELECT servicename, service_account
FROM sys.dm_server_services
GO

Syntax

Creating Indexes

Create a unique index

CREATE UNIQUE INDEX idx_tablename_columnname ON tablename (columnname);

Create a clustered index

CREATE UNIQUE INDEX idx_tablename_columnname ON tablename (columnname);

Create a non clustered index

CREATE INDEX idx_tablename_columnname ON tablename (columnname);

Literals with Join

The VALUES constructor can be used to create a table of literals for use inside a query:

SELECT *
FROM (VALUES (@Id, @title), (1123, 'title')) AS literals (Id, Title)
    LEFT JOIN Table_Name ON Table_Name.Id = literals.Id

Table Types

View user-defined table types

SELECT * FROM [sys].[objects]
WHERE [type] = 'TT'
ORDER BY create_date DESC