Page 7 - Simon's SQL

T-SQL & Scripts

Selecting Rows Randomly from a Large Table

T-SQL & Scripts

SQL Server Job Agent - Invoke job sequence.

T-SQL & Scripts

OpenXML parentID

Troubleshooting

Token-based server access validation failed with an infrastructure error, Error: 18456

Troubleshooting

sp_rename will not change sys.syscomments table definition.

T-SQL & Scripts

Excel import using XML and T-SQL

Performance & Tuning

TempDB Misconceptions around TF 1118

Troubleshooting

Bulk load data conversion error (overflow) SQLINT (BCP)

Performance & Tuning

Paging file for SQL server

Backup & Recovery

BACKUP DATABASE TO DISK = N‘NUL’

T-SQL & Scripts

uniqueidentifier : GUID in SQL

Community & Talks

Contact information