Why do TRUNCATE and DROP TABLE complete so fast?Commented on: 2 years ago
(June 27, 2012)
Just gave this a try. I created a large table, truncated the table and looked at the log file size (no change). I then looked at the log file size again just a few seconds later and sure enough, it...
When compared to AlwaysOn Failover Cluster Instances or clustered deployments of SQL Server, one of the main problems with AlwaysOn AGs is that a single database is made to straddle multiple hosts....More