Categories

28 pages

T-SQL & Scripts

sys.sysobjvalues

Global ErrorLog SP example

SSIS Catalog Execution with T-SQL

DBCC help(‘?’) want to see all hidden DBCC command

Alert email sending

Selecting Rows Randomly from a Large Table

SQL Server Job Agent - Invoke job sequence.

OpenXML parentID

Excel import using XML and T-SQL

uniqueidentifier : GUID in SQL

Cross-Database Access

Snapshot and Synonyms