If you copy the script from the web page into a SQL query it contains non-printing characters that Transact-SQL does not like. If you copy the script into notepad...
Add a lightning-fast way to encrypt and decrypt data. Even following Microsoft's suggestions to combine symmetric and asymmetric functions, performance isn't there. And what about indexing on encrypted...
The truncate solution seems best, but if you really get stuck having to delete millions of rows, one technique that has worked for me is setting a rowcount of something...
You might want to add the page_count when you check for fragmentation so you don't spend time rebuilding indexes on small tables that don't fill more than one page.
I've inherited a system in which all the foreign keys are disabled and triggers are being used to enforce referential integrity. The nice part about this setup is that...