Good luck.

I'm writing this one on friday morning. Still need to work through two of the course guides. :Whistling:

Shall we compare results monday morning?

Datalength works on text and ntext data types where len does not.

Ananth (12/10/2007)

---

whether index scan reads the data from index or table? if it reads from the table then there is no advantage of this index scan because , it is...

You can, but you will have a performance impact. How much depends on your hardware and the activity.

Try shrinking in smaller chunks. Sometimes that works out faster overall. Even if...

It didn't change in 2005. I don't know about previous editions, because I started with SQL 2000, but 2000 also had no issues with null bit columns

Yeah, I saw it. I even read it, twice.

I'm commenting on the cursor as much for the benefit of anyone reading this who might otherwise think that's a good way...

Tell me...

Functions are not allowed to have side effects. No data changes, no schema changes, no config changes.

Can you convert it to a stored procedure?

I still need to convert some of my crappy string manipulation functions to CLR. I'm betting on a CPU usage reduction if nothing else.

There are things that can be done...

Ow! Cursors (or while loops) in triggers are very bad...

I my experience, the traceflag is the best way to get deadock info, as you don't need any form of monitoring running. You can see deadlock graphs in the error...

I saw, I thought it was worth saying again in stronger terms.

Besides, isn't imitation the...

It's a multiple choice and simulation exam. You won't have to write code. You may need to select the correct version of the command from a list, so you should...

As for your original question.

On a insert, the inserted table will be populated and the deleted will be empty. On an update, both the inserted and deleted tables will be...

I'm not sure why this is deadlocking, as statements within a transaction cannot block each other.

If you look through the deadlock graph, can you find any reference to a...