Weird.

What problems is it causing?

Yes, it affects lots of things.

when i run the query it always taking non clustered...

Server regional settings?

And no, sessions 1-50 are not system sessions, that distinction hasn't been true since pre-SQL 2005. Sessions over 50 may be system as well. Rather use the is_user_process...

Doesn't matter. Part of the 'cleanup' when the procedure ends and the temp...

Of course it it. It's still the only operation in the batch, the costs have to add to 100%, that's...

Well, of course it is.

Costs have to add up to 100%, so...

No, it's not a good idea to include all columns. Clustered indexes should be narrow, that one is not.

http://www.sqlservercentral.com/articles/Indexing/68563/

As for how you test, identify the frequent queries which run against...

What, exactly, do you mean by 'performance of the clustered index'?

I think my sysadmin would love that one.

No idea.

This is not the kind of problem that can be solved with a couple of forum posts. I suggest you consider getting a good SQL consultant in (I can...

The problem with the dance shirt is, knowing my colleagues, some of them would ask for the interpretive dance. Probably multiple times.

Other editions can't create explicit snapshots, so no. And snapshots are useless for backup purposes, they can't be used for backups, they have no advantages when there are backups running,...

Hahahaha

One of the managers complained this morning that, as far as he can tell, most of my wardrobe is made up of geeky t-shirts. I'm...

Just be careful of any possible legal implications (what happens if someone uses the same password for your system and their online banking, you cracked their password as part of...

Oh, and just noticed that I've passed 40k points again. Only ~3000 to go to get to where I was.

Steve, btw, I didn't even get a T-shirt for the first...