Categories

28 pages

T-SQL & Scripts

Errorhandling

RAISERROR : Database Engine Error Severities

server information include port #

Disk IO Response time In SQL

Array to table for multi dimensional

Find out sql job start time and end time

XACT_STATE or @@Trancount (To control Nested Transaction)

Converting from hex string to varbinary and vice versa

permission test.(impersonate)

Available File group size

object size each table and index (update for partitioning table)

Disk IO response time check.