Try

LIKE '/%' ESCAPE '/'

Thanks. I'm planning to put a similar trigger on a couple of my servers. Good to know about the execute as

And don't forget Books Online

You would see reduced space used, how much depends on the size of the rows and the number of rows in the table. You'll only see the space reclaimed after...

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           ...