Hi,

the situation hasn't changed ... The values I posted a while ago are still the same.

I think that this simply requires application code rewrite... which is not really something we...

Yep, as I expected when I read your post.. I forgot a FETCH in the first loop ...

An infinite loop is never good except when it's what you want...

Here...

Thanks for the reply.

Instead, I used powershell's Copy-Item command let.

Hi, first of all thank you for sharing.

I'm on the way to implement the same kind of thing but all under stored procedures.

I have a problem with the xcopy...

Yes, it gives you a guideline for implementing database mirroring :

1. you backup your database you need to mirror

2. you restore your database on the off-site server

both FULL and...

Thanks for your comment.

I would say, it's just a starting point ...

I work on a set of scripts written in perl (I'm not a big fan of Powershell for...

Hi, thank you for the comment.

I'm primarily an Oracle DBA so, there are kind of things like that I don't know. It's a good idea. I'll update it in a...

Ok, thank you for your analysis.

Hi, it's a 64 bits system, Windows Server 2008 R2 SP1.

The memory settings are Min memory = 4Gb, Max Memory = 7Gb.

Index rebuild is done every day. The statistics are...

Yes, just before an index creation... But I'm very surprised because it's a script generated via SSMS, and I can't get to it working at once :w00t:

By the way, I generated the whole database script and suppressed the references to TEXTIMAGE_ON... I now get this error

CREATE INDEX failed because the following SET options have incorrect...

And I suppose the only way to "sanitize" is to make a clone table, copy data from the currently used table and switch ... There is no way to clean...

As I said, it's an external DB for an application developped by another company. I just took their .BAK file and restored it. I don't know the history of that...