Hello Victor,

Sadly enough, yes I need all of those columns. The view has been specifically built for a salary report, and there's a lot of fields for vacation, overtime types,...

Hi Victor,

Providing a full DDL might be a bit problematic, as there is several pages of fields in there, so I'll try to keep it short while still providing...

Here they are. The view has grown in between, and so the execution plan has changed somewhat, but the resulting amount of time is still the same.

Hi GSquared,

The main costs in both execution plans are in the joins. They both do a clustered index scan on the primary key, which is the usual autoincremented ID field....

Back again! As promised, that resultset:

Start of the arrangement:

regeling_id regeling_code regeling_omschrijving regeling_startdatum

------------ -------------- ---------------------- --------------------

1 TEST...

@Wesley:

Yeah, I kind of already was thinking along those lines as soon as you mentioned the idea.. I'm playing with the idea to do that with a temporary table perhaps...

@Bhuvnesh:

There's a select query which last column gives me a date near the bottom of the script.

I want that date replaced by a 1, 2, or 3 (the...

Hi Lutz,

I've read the article linked to your topmost signaturelink, and I've come up with the following. Hope it becomes clear enough. 🙂

/* Generating and populating tables. */

CREATE TABLE...

Hello all,

Again my problem occured. I have the following results per your suggestions:

EXECUTE sp_lock :

I am not sure what these columns are supposed to tell me, but the type...

Thanks for the input folks! I had to do it manually again yesterday, after which time I know things will run smooth for a while, but then I'll keep this...

Thanks for your reply!

I've tried your two commands and gained the following information:

The select query tells me that the cmd field of the process in question is AWAITING COMMAND

The stored...

Now that's unfortunate.. ah well.. thank you again for your time!

Hi Ian,

I've looked at your screenshot, but I don't have the option greyed out... I've attached the image as it looks here..

It's unfortunate things like these happen, but luckily...

That at least proves that the related project could not be the issue.

I have no clue either. I happen to have things like these quite often.

Impossible situations which...

Hello Ian,

I tried to type you a message, but there was an error. In short, could you try to run the SP without an active project for me? Thanks for...