This statement is directly copied from Axapta (ask Bill 🙂 )

The 4 parameters are actually not very special, @P1 and @P3 are the same, a 3 digit company identifier. @P4...

Shrinking the database will lead to fragmentation.

could you give the following information:

- memory for MSSQL server

- where data and logfiles are placed (on same disk?)

- How heavily is tempdb used and where are those tempfiles placed...

It's a misunderstanding that LDF files are not used in SIMPLE mode. Every transaction is recorded in LDF files, regardless of the recovery mode. But if your database is in...

Thanks for your reply.

I added the executionplan, but this is as it runs now (performing well).

I'll add another version if it's performing bad

Forgot to say:

- Os is windows 2003 enterprise 64bit

- MSSQL is 2005 Enterprise 64bit with SP3

- 32GB memory, 27GB for MSSQL

- dedicated (non-virtual) server

"Let me see ... seems your for an amputation of your left leg?"

"No ?? .... Aha! My appointment is B5010D2A-F8F9-482B-AC29-C1351ECE52C8"

"Oh yes, you're pregnant, let's see how the baby is doing"

:-D;-)

Ever thought about the datatype "'UNIQUEIDENTIFIER" ?

You're starting from the wrong direction. First, specify your requirements (how many databases, type of database, how many users, which features do you need etc) This leads to a server...

seems microsoft did not post the correct zipfile. Send a message to them with this error.

instead of a failover cluster, consider a mirrored database with a witness server

A large logfile means something is running on your database. Did the full backup ran properly?

Check databaseactivity: Is the logfile still growing? There must be a process which is blowing...

Seems this article is also in random order ? :-D:-D

There are a lot of options, but these wil depend on the amount of data and your network configuration. For example, you could:

- backup the source database and restore it...

- You're sure the slow response is not caused by another issue? (network, other resources on the server)? (Can you reproduce a "slow" query?)

- You're sure the indexes are not...