Thanks for the information Paul.

It's running on the Web edition actually, so I'm not sure where exactly does it stand with the ONLINE/OFFLINE operations, but it doesn't matter much, defragmentation/table...

I'm far from being anything close to SQL expert or a DBA, so bear with me please.

I've come across Michelle Utford's script before - if I understand the note in...

Thank you, I'll try look into that.

Thank you.

I agree, but it's the application (3rd party) that creates the DB names like this, so there's little control over it.

Thanks Elliott, works like a charm.

Thanks Elliott, I'll try out your suggestion.

It's a big deal, because the database names can contain VAT ID numbers of companies or their names and since multiple clients "coexist" on...

That's what I was afraid of, but thanks anyway for confirming.

Then I also guess there's no way to create a user on the SQL server without him being member of...

Grant, thanks for the responses.

We did further testing and the result was surprising and confusing.

Originally we thought the difference is caused by different OS (W2k3 vs W2k8), architecture (x86 vs...

Is there an easy way to find that from the execution plan? I've looked at the ex. plan, but it's too complex and I'm not sure what exactly to look...

Well, that might be a problem, since I'm not a DBA, I'm a sysadmin with not so deep knowledge of SQL.

I'm aware of the fact, that I'm comparing apples to...

Thanks alot for the prompt reply. One more (reassuring) question.

If...