This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.

This Azure Automation runbook provides an example of how Azure Automation can be used to execute SQL Agent jobs in the cloud. This example demonstrates how to truncate a table if one or more database ...

SQL Server 2005 or later script to generate TRUNCATE statements for all tables. Anyone that has tried this on anything but the most simplistic database has found, as I did, that this won't work. Any ...

When you have a clustered index the table gets physically rearranged every time you insert.<BR><BR>One of my most common moves is to insert into new table, drop old, rename new, add indexes. ••• ...