ankur_libra (12/29/2011)

---

Hi,

Thanks to all for response, however problem still there..

SQLRNNR : Yes, Taken database backup in compressed form on local disk

Michael : I have also taken backup using compression on...

I leave backup compression turned on by default, and turn it off only for backups of specific databases that have very low compressibility.

Even though compression uses more CPU, the reduced...

Gianluca Sartori (12/28/2011)

---

NOLOCK? :sick:

With RCS enabled writers don't block readers. Is this the kind of concurrency issue you're trying to address?

As far as the dangers is concerned, you could read...

GSquared (12/29/2011)

---

Michael Valentine Jones (12/28/2011)

---

GSquared (12/28/2011)

---

Michael Valentine Jones (12/28/2011)

---

GSquared (12/28/2011)

---

Michael Valentine Jones (12/28/2011)

---

I don't see how RCS would be a problem in a data warehouse\datamart application.

If there are no inserts/updates/deletes...

David Moutray (12/28/2011)

---

RCSI wouldn't permit dirty reads, but it would permit non-repeatable reads and phantom reads. Since the required overhead for the Temp DB is significant, I want to...

GSquared (12/28/2011)

---

Michael Valentine Jones (12/28/2011)

---

GSquared (12/28/2011)

---

Michael Valentine Jones (12/28/2011)

---

I don't see how RCS would be a problem in a data warehouse\datamart application.

If there are no inserts/updates/deletes happening, then there are...

GSquared (12/28/2011)

---

Michael Valentine Jones (12/28/2011)

---

I don't see how RCS would be a problem in a data warehouse\datamart application.

If there are no inserts/updates/deletes happening, then there are no row versions being...

I don't see how RCS would be a problem in a data warehouse\datamart application.

If there are no inserts/updates/deletes happening, then there are no row versions being generated in the version...

Set your backup to compressed. Better yet, make that the server default.

That will reduce the size of the backup and the amount of data you have to send over...

If you are in the SQL Server sysadmin server role, you can issue the following command from a query window to stop the SQL Server service. It will also...

SELECT TOP 1

a.f1

FROM

(

SELECT TOP 2

b.f1

FROM

tmp2nd b

ORDER BY

b.f1 ASC

) a

ORDER BY

a.f1 DESC

dtwilliams (12/16/2011)

---

That's a great idea. I sort of had that theory in my head, but couldn't for the life of me think how to do it for looking too hard...

Are you running 32 bit or 64 bit Windows?

If you are running 32 bit Windows 2003 R2 Standard Edition, it can only access 4 GB of RAM.

If you need more...

It sounds like what you really need is a related table that is a queue of Bookings in the TBA status, something like BookingTBAQueue.

Insert a row into the BookingTBAQueue table...

Computing the age of someone is more difficult than it might seem when you take into account different month lengths, leap year, and other things.

This function returns age in years.

Age...