Here's why it's just a might... I converted a big proc from using ±10 table variables to temp tables. Here are the stats after I had done all...

Do you have to run that code more than once for the same folder?

Is there any reason why there's no promary key on the image id column?

Then there has to be another row in the table to contain the rest of it. syscomments works exactly like that with the text column and colid (rowid).

The tail backup is a way to say the "final" log backup to get the latest transactions since the diff.

As for compressing the backup, it might be worth spending the...

r_slot (4/19/2011)

---

Thanks for your code (very, very fast production - that must be a pro): for simplicity I made the same directory as you did (D:\test img\) and its running...

Thanks for helping me help YOU.

USE [tempdb]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE dbo.Renner_Foto (

[ImageID] [int] NULL,

...

We're on a rather fast san here (48 1TB drives 15 K rpm.) It would take over 100 minutes to copy 100 GB.

One way to do it is to...

So you want me to do the work for you and you won't even want to supply to tools I need to test the code? I need a zip...

Can you zip me up a couple dozens of the pictures? I'll finish the code for you.

Th eonly obvious part is that either you have a begin tran /...

CREATE SEQUENCE in SQL??? Care to catch me up Joe?

I mean copy - paste this into SSMS. Then run the code 1 line a t a time and see what works and what fails and WHY.

Repeat process untill...

Well if you actually run begin tan / rollback tran you certainly won't have anything left in the db after you run the code!

Fine, assuming the log backups are running fine.

Shrink the t-log a couple minutes before the reindexing. And see how big it grows back to after the job has run.

Even...

r_slot (4/19/2011)

---

I think your error has to do with the filepath, more specific the space in [Mijn Documenten]. If you put that piece of code between "" the problems should...

REINDEX ??????????????????????????????????????????????????????????????????????