SQL Server Syntax

 Length and data type for some common database fields.
 dimTimes Create a Time Dimension table.
 dimDates Create a Date Dimension table.
 Backup check - list SQL backups completed in the last 24 hours.
 SQL Server & Oracle Versions and features.
 spRemoveLogin remove SQL logins.
 SQL Server Version and Service pack.
 List SQL Instances (PowerShell)
 List Compatibility mode for each database.
 Find the largest objects.
 Trace Flags.


 Microsoft Books online: SQL Server 2016
 Links to other Sites, books etc...
 SQLCMD   Command prompt utility for T-SQL 
 SQL Server Version numbers

Copyright © SS64.com 1999-2018
Some rights reserved