Beginning with SQL Server 2008 R2, there’s a significant difference in the amount of memory that SQL Server can allocate from the OS to its buffer cache ( Buffer Pool ). An Standard Edition will not grow it further than 64GB, no matter how much...

Even though it might work, never attempt to do that. As the documentation clearly states: it is unsupported. In topic Prerequisites, Restrictions, and Recommendations for Database Mirroring , Books Online shows a Prerequisites section where it mentions...

Not much, really. There is a topic in SQL Server’s documentation about the Limitations of the Missing Indexes Feature . In this post, I want to discuss about the one limitation enumerated in that list, included in the referred topic, where it describes...

During a crash recovery or a database mirroring failover, SQL Server Enterprise Edition (or a Developer Edition or an Evaluation Edition, both of which behave exactly like the Enterprise does. The only difference among them three is their licensing.)...

Yesterday, while co-delivering a seminar on Database Mirroring to a few customers, one of them asked whether it was possible to open Database Mirroring Monitor in an easier, more straight forward way than having to open SQL Server Management Studio, connecting...

If you want to have the possibility to restore data on a database while it is already online (i.e. whenever its primary filegroup is online) you can do so only if you are running the Enterprise Edition (or a Developer Edition or an Evaluation Edition...

Increasing the reliability of your backups by providing redundancy is something you can achieve with SQL Server’s mirrored backups , which is an out-of-the-box feature available only in the Enterprise Edition (or a Developer Edition or an Evaluation Edition...