Click here to Skip to main content
15,906,816 members
Home / Discussions / Database
   

Database

 
GeneralRe: Partial update via OleDBDataAdaptor Pin
Dan Neely27-Jun-07 5:40
Dan Neely27-Jun-07 5:40 
GeneralRe: Partial update via OleDBDataAdaptor Pin
Dave Kreskowiak27-Jun-07 5:55
mveDave Kreskowiak27-Jun-07 5:55 
QuestionI want to secure my DB Pin
merwa27-Jun-07 2:35
merwa27-Jun-07 2:35 
AnswerRe: I want to secure my DB Pin
Vasudevan Deepak Kumar27-Jun-07 2:47
Vasudevan Deepak Kumar27-Jun-07 2:47 
QuestionSQL Server 2000 mirror Database Pin
AcDev727-Jun-07 1:01
AcDev727-Jun-07 1:01 
AnswerRe: SQL Server 2000 mirror Database Pin
Mike Dimmick27-Jun-07 2:24
Mike Dimmick27-Jun-07 2:24 
GeneralRe: SQL Server 2000 mirror Database Pin
Colin Angus Mackay27-Jun-07 12:19
Colin Angus Mackay27-Jun-07 12:19 
GeneralRe: SQL Server 2000 mirror Database Pin
Mike Dimmick27-Jun-07 23:30
Mike Dimmick27-Jun-07 23:30 
They left it at 'experimental' - you had to turn on a trace flag to get it to work. With this level of confidence in the feature I would recommend applying the service pack before trying it.

I'd recommend not using mirroring for a database with a high level of write activity (say, ASP.NET session state). For a start, you need to use the Full recovery model, which means that the transaction log just grows until you back it up. We're using a SQL Server database as a shared state store for our thin client product, when used in a server farm mode (for load balancing and failover), but due to the requirements of the protocol the database gets updated multiple times per client request. I think I can probably get this down to two. Anyway, because the Mirror partner has to acknowledge all transactions, you get a delay of several milliseconds (normal cross-machine call overhead) on committing every transaction, which slows down your client quite a bit.

In fact I found in in-house testing that if the Mirror went offline for a while, the transaction rate went up a lot. When the Mirror came back online it could never catch up with the transactions that had occurred while it was offline. At least, on the low-end white-box hardware that I was testing with.

For mostly-write databases, clustering is a better solution than mirroring.

Stability. What an interesting concept. -- Chris Maunder

QuestionStored procedure Pin
sidbaruah26-Jun-07 23:36
sidbaruah26-Jun-07 23:36 
AnswerRe: Stored procedure Pin
mamatha_raghu27-Jun-07 0:17
mamatha_raghu27-Jun-07 0:17 
AnswerRe: Stored procedure Pin
Pratik Vasant Shah27-Jun-07 19:44
Pratik Vasant Shah27-Jun-07 19:44 
Questionmysql input with stored procedure help Pin
boyindie26-Jun-07 23:20
boyindie26-Jun-07 23:20 
AnswerRe: mysql input with stored procedure help Pin
Devkranth Kishore Vanja28-Jun-07 20:42
Devkranth Kishore Vanja28-Jun-07 20:42 
GeneralRe: mysql input with stored procedure help Pin
boyindie28-Jun-07 21:48
boyindie28-Jun-07 21:48 
Questionsharing sql server without client installation Pin
mamatha_raghu26-Jun-07 20:41
mamatha_raghu26-Jun-07 20:41 
AnswerRe: sharing sql server without client installation Pin
Manas Bhardwaj26-Jun-07 22:24
professionalManas Bhardwaj26-Jun-07 22:24 
AnswerRe: sharing sql server without client installation Pin
originSH26-Jun-07 22:29
originSH26-Jun-07 22:29 
GeneralRe: sharing sql server without client installation Pin
mamatha_raghu27-Jun-07 0:06
mamatha_raghu27-Jun-07 0:06 
GeneralRe: sharing sql server without client installation Pin
originSH27-Jun-07 1:06
originSH27-Jun-07 1:06 
AnswerRe: sharing sql server without client installation Pin
Mike Dimmick27-Jun-07 2:46
Mike Dimmick27-Jun-07 2:46 
QuestionSequence of events/methods execuion in SSIS Pin
I.explore.code26-Jun-07 19:57
I.explore.code26-Jun-07 19:57 
Questionpull subscriptions Pin
SVb.net26-Jun-07 12:58
SVb.net26-Jun-07 12:58 
QuestionDatabase design for exam system? Pin
HinJinShah26-Jun-07 8:08
HinJinShah26-Jun-07 8:08 
AnswerRe: Database design for exam system? Pin
Ashiq Shaikh26-Jun-07 22:56
professionalAshiq Shaikh26-Jun-07 22:56 
GeneralRe: Database design for exam system? Pin
HinJinShah27-Jun-07 6:31
HinJinShah27-Jun-07 6:31 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.