I haven't seen mention of this important NULL topic anywhere:

select 1

where 1 = 1 or datediff(hour, null, getdate()) > 4

TSQL seems to work like this:

where True OR NULL = True

where...

I sometimes use this to count NULLs

sum(case when [Field] is null then 1 else 0 end)

don't know how performant it is though

can be useful like this also

having sum(case when [banana]...

1) the download size is 144mb

2) then it decompresses

3) then it calculates the indexes

4) the indexes are stored in the windows folder

5) every product that integrates with microsoft help system...

I wouldn't download the BOL

use the lightweight online version

http://msdn.microsoft.com/en-us/library/ms130214.aspx

I would avoid the (extremely bad) microsoft local help system

the online versions are much quicker

that is unless you like:

- waiting...

Jonathan Kehayias (2/3/2009)

Take a look at the article from yesterdy. A missing/incorrect index can most definitely be the cause of a deadlock. In fact most deadlocks are simple...

SQL 2005 has xml deadlock report in profiler

which will track deadlock down to tables and stored procedure statements

I think your solution does not solve the deadlock - just makes it...

Some very nice techniques and ideas in the article

But I have never rolled back a change to a production database in 10 years.

Your energy would be much better spent ensuring...

when I design a application / database it is a balancing act between:

- performance

- manageability

- simplicity

- flexibility

- etc.

every table design decision has implications for views and stored procedures

every view design...

The application developer should be the DBA of his applications' databases.

Separation of roles results in low quality results.

Integration is the route to high quality and efficiency.