Personally, I would logship the database and set up the publication and subscription with out initialising from snapshot. You could bring replication online within a couple of minutes doing...

Its not really an error. Its pretty self explanatory. The subscriber has not communicated in the expiry period as dictated by your publication and the clean up job...

It is delphi in a way as you would open a sql transaction in delphi code and fire each insert individually. In the event of failure the catch block...

tnt750 (1/25/2012)

---

can you help me for solve this problem in best way and power full?

my records first save to string gride in my program that written by delphi

then user click...

How do you mean move 1000 records from a client? What format is it stored locally?

russ.guier (1/25/2012)

---

To the Scary DBA I read your review of SQL Cop and it looks like an excellent tool The piece I like about DIAB "And I have been a...

This thread is stale to the tune of 18 months

"Depends" on the size of the database and its logfile. Based on average database size its likely to be on the high side.

HowardW (1/20/2012)

---

Ok, yes, FusionIO sounds awesome, but I wouldn't group it in with in-memory databases - it's...

Questionable.

HowardW (1/20/2012)

---

Would you really want to completely destroy your database if you had a power outage, or...

I'd also point out that my note worthy databases regularly hit 5 figure tps without disk issues so it is possible to have this provided your environment is configured correctly....

Lead

Grant Fritchey (1/20/2012)

---

SQL Server doesn't have an in-memory setting. It works as it works and the disk is heavily involved. But if you're not seeing disk queuing, why would having...

Are the database transaction logs on a different drive to data? Which drive do you see disk queues?