SQL Server 2012 High AvailabilityCommented on: 2 years ago
(August 10, 2012)
>>It absolutely does not apply to restore operations.
your comments is making me more confused. Are you saying that RESTORE does not do Crash Recovery. I though REDO and UNDO are...
Why can't SQL Server update statistics on the fly?Commented on: 2 years ago
(November 7, 2011)
When come to indexes and statistics; I find your insight into those areas as subject matter expert very helpful.
Excellent. Anyone reading this article I encourage him/her to watch your...
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.
In managing a database or sometimes numerous databases, we often get caught up in the day-to-day maintenance and lose sight of the other principles we know are critical to ensuring optimal performance. Here’s a quick refresher....More