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.

Related

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

© Copyright SS64.com 1999-2016
Some rights reserved