SQL Server How-to guides and examples

 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

 Transact-SQL reference
 Links to other Sites, books etc...
 SQLCMD   Command prompt utility for T-SQL 
 SQL Server Version numbers

 
Copyright © 1999-2024 SS64.com
Some rights reserved