SQL Feeds - All your SQL feeds in one place.

Monday, February 09, 2009

Minimize downtime with DB Mirroring

by kevincox via Microsoft SQL Server Development Customer Advisory Team on 2/9/2009 8:55:00 PM

At one high volume OLTP project we are involved in, the customer likes to use DB Mirroring to minimize downtime for planned failovers.  This usually involves patching either Windows or SQL Server.  The interesting part of this strategy is that they switch to synchronous mirroring just before doing a failover.  They would normally like to run with synchronous mirroring but their volume is too high during the day to keep up.  So they run asynchronous mirroring until just befor ...

[ read more ]

Conor vs. Non-ANSI NULLs, part 1

by Conor Cunningham [MSFT] via Conor vs. SQL on 2/9/2009 7:45:00 AM

I was thinking about indexed views. Well, more specifically, I was thinking about why indexed views are hard to use. One of the reasons that they are hard is that there are just so many restrictions. Anyways, one of the things I'd like to better understand...(read more) ...

[ read more ]

Subscribe

New Feed

Product Spotlight

Recently Updated Sources

Legal Note

The content of the postings is owned by the respective author. SQL Feeds is not responsible for the contents of the postings. This site is automatically generated and cannot be reviewed for abusive content. If you find abusive content on SQL Feeds, please contact us. Designated trademarks and brands are the property of their respective owners. All rights reserved.

Advertise with us