I can recommend the suggestion of Ian to work in SQL Query analyzer and use drag and drop. It helped me a lot.

Thanks for the great explanation of this problem....

Better Late then not at all.

Thanks for the confirmation.

I am executing tests now and I will report later.

I am still very interested in a suggestion for a SP that chops...

Thanks Matt.

Thanks Jeff. I go for it.

Menno

OK Jeff and Matt,

I have deactivated autoshrink and I will plan better :D. I learned a lot in a few post from you all. Thanks.

I ran the estimated execution plan...

OK Jeff, So no shrinking! Is there any point in time that shrinking is good?

Menno

OK Jeff, I suppose you suggest to turn off the autoshrink. Shall I do this in the overnight procedures? By the way the users are on a cube based on...

Ok Thanks

Hi Ian,

This is the main facttable:

CREATE TABLE [dbo].[FactsDossiers] (

[Admincode] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

[Broncode] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

[Klantcode] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

[Dossiercode]...

Hello Ian,

This is the view: Update_Factsdossiers_Maatregelen_financieringsstatus

SELECT dbo.DimAdmincode.Bedrijfstype,

dbo.FactsDossiers.Admincode,

dbo.FactsDossiers.Kengetal AS Referentiekengetal,

dbo.FactsDossiers.Samenloop AS Samenloopdossier,

dbo.Filter_datum_Tijdpunten.Datum AS Referentiedatum,

dbo.Filter_datum_Tijdpunten.DagBoekjaar AS ReferentieBoekjaar,

dbo.Filter_datum_Tijdpunten.DagPeriode AS Referentieperiode,

FactsDossiers_1.Kengetal AS updatetargetkengetal,...

Thanks Jeff,

I have the auto shrink on. I will check if the "truncate log on checkpoint" is on. Is it to find in the settings or do I have to...

OK thanks Matt.

Thanks Ian, This is the case. I use large queries with complex joins. I connect them to look up values and depending on the value change record status. These queries...

Hi Barry,

The recovery model is already set to simple. Do you have additional options in mind?

Menno

Hi Matt,

I want to try to set the temp DB to a larger start size. How can I do that?

Menno