When you create a primary key you can make it clustered or non clustered. Check books online for the syntax. The only way to change from clustered to nonclustered is to...

Ah, OK. I've had people ask me for actual questions before.

A few things about sims that I picked up from my windows server exam -

You can reset the sim,...

Ow.

Cursors are never a good way of doing things in SQL. Set-based operations are far more optimal. Try something like this (untested).

CREATE...

No one's going to gve you an actual question from the exam. It's against the non-disclosure rule.

When I wrote 431 there were no sims in it, but I had them...

Iterating through rows is never a good idea in SQL. Set-based operations work much, much faster.

Could you post your revised trigger here please? Might be able to get something more...

but I guess it could well be automatic recompilation in light of the number of rows

If it was, you'd see the number of recompiles/sec higher than expected. Automatic or forced...

Your best bet would be to log on to the server in question and check terminal services manager. That will show you where the terminal services connection is coming from.

Check what the waitresource is for the blocked processes. If it's due to recompiles then the wait resource will read something like TAB 11:1:4525466845 (Compile)

Inserts and updates will take locks...

Please post some details when you get a chance. I'm interested in seeing what you're doing.

The other issue is if there are stats and you create an index the stats remain, so its something esle to update and maintain.

I didn't realise that, though it's obvious in...

ec_pss->pspid = 73        ecid = 66                 ec_stat = 0x0             

ec_stat2 = 0x40001        ec_atomic = 0x8           pcurdb = 7                

ec_lasterror = 0          ec_preverror = 0          ec_cpucur = 4294967295    

ec_cmderrs = 0           ...

Pleasure.

Couple problems here. The first, and the one that you're noticing is that you don't do comparisons to NULL using = or !=. The rules of NULL comparisons say that...

Can you be a little more specific about what you're trying?

In general, for performance question, my first answer is 'try both and see which is better'

Then all you're looking for is a simple, one row insert.

When the user registers fire off a stored proc that just inserts that userID into your custom table.

CREATE procedure [dbo].[getcustomProfile]

@UserId...