T-SQL Deep Dives: Create Efficient QueriesCommented on: 4 years ago
(July 20, 2010)
Itzik, I ran your TOP Vs MIN\MAX example on a SQL2005 (build 4035) box and the 3rd Query still does not do an Index scan and in fact it does 27972 logical reads, as opposed to 9458 reads using MAX or...
Digital Magazine Archives
Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.
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