• Edit
• History
• Print
• Backlinks

SQL Tips

This will be a collection of useful tips, techniques &tc.

• Documentation — password protected
• Setting Up a MAPI Mail Profile on SQLServer
• XPSendMailWithRecipientsFromAQuery
• The Perils of Fibre Mode
• RenamingAFileAfterImportingViaDTS
• ImportingTheLatestFileInAFolderViaDTS
• IndexCreationGuidelines
• ErrorHandling
• SystemAdminChecks
• LockingDownDTS
• SQL Dos and Don’ts
• Exporting to an Excel File from DTS
• Specifying Joins in FROM or WHERE Clauses
• SQL Server and Source Control Systems