Have used SQL Diagnostic manager since it was sqlprobe, back in 1999 or so.

I tend to use a lot of my own tools however it all depends what you expect...

Let's clarify something: The parallelism setting has absolutley no bearing on cpu use, all it does is allow or limit parallel plan generation.

I seem to remember we had a...

sorry didn't read all the scripts correctly - you illustrate correctly why calls to objects should always be fully qualified.

I would expect to have to always fully qualify objects, I'm not a great lover of schemas for schemas sake, I've seen a number of implementations of schemas just because...

if you can't delete them they probably are not orphaned.

look in services - the name of the instance will be there, sorry don't have an instance to hand to explain more.

yes there's a stong chance anything which truncates a guid or uses the rnd function will generate a duplicate.

are we talking about page file usage here?

If so then if you have a page file it will get used no matter how much available memory there is. I find...

I did a series of posts on analysing indexes on my blog/website - pretty much all you need to know is in there

I think you're asking too much here and I'm not too certain this is an easy task in T-SQL. A guid will give you 32 chars which should be unique,...

I would assume that sql 2005 has installed as an instance, ssms will always tend to pick up the default instance first, you need to find the 2005 instance, look...

aha - been there too. I'd sometimes like to shoot the sytem folks who set silly o/s partitions - unless you fix your environment variables you'll find a profiler trace...

In all my tests so far DAS has outperformed the three SANs I've been working with. I'd avoid sata drives like the plague except for achive work, they generally only...

Too true you'll have problems. Sadly I can understand this situation - check for what's using the space - the rubbish bin sometimes hold files even after the bin...

I wonder if this post is getting somewhat lost somewhere?

1st point - there is no relation between the page file and sql server or any sql server settings what so...