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...
While AlwaysOn Availability Groups are a powerful solution that let DBAs tackle both high availability and some disaster recovery concerns from within a single, unified, set of technologies and tooling, AlwaysOn Availability Groups also come with a number of challenges....More
For some businesses, conducting a health check can be cumbersome, time-consuming, and the results, well, frustrating. However, a health check can be easy and rewarding for any business that wants to improve server performance, especially if you take the time to find the right solution provider....More