You have a de-normalized structure - storing multiple values in the same field violates the 1NF itself.

Since you are storing multiple values in TEST1.ID field and those are separated by...

Take a look at the materials provided by Transcender..the coverage and the materials they provide are pretty good.

http://www.transcender.com/dept.aspx?dept%5Fid=100400

Non-clustered index on the PK of the parent table.  You can try it out using the scripts given above.

The pages in the data chain and the rows in them are...

Using the table structures and data provided by Farrell above, you can also do this:

SELECT USERS.USERNAME,

MAX(CASE WHEN DIVISIONS.DIVISIONID = 1 THEN DIVISIONNAME ELSE NULL END) DIVISION_1,

MAX(CASE WHEN DIVISIONS.DIVISIONID =...

Determine the max number of strings that any given key value can have since that is what will decide the number of columns for you once you convert the rows...

It also has an effect on the locking behavior (it is one of the best practices to index your FKs)...one such example to show how locking behavior gets effected because...

Your updates (and the select for updates i.e. WITH (UPDLOCK)) have to be based on indexed columns otherwise you will be locking the entire table.  Right now, you have a...

Q1) Is there a foreign key relationship between CALLLIST and CAPTURECALLLIST ?  If so, is the foreign key indexed ?

And what type of index is it on the PK ?...

Without looking at your table structures, their indexes and the queries involved, this becomes tough but here goes:

The deadlock occurs when the update statement on B is being run (btw,...

What is the data-type for the variable to which you assign it after reading from the database ?  Is it a string ?  If so, then it will read the...

Enable 1205 and 3605 as well and then look at your deadlock output since that will shell out more information for you.  The actions that occur as part of the trigger...

And if these databases happen to be on separate instances, then look up BOL for "linked servers".

Besides pessimistic (lock upfront) and optimistic (based on either a timestamp data-type or an integer column) concurrency models, in a scenario like the one that you have described where you...

Not true.  You can create indexes on views in Standard Edition as well.  Here is the quote from BOL:

/******************

Note  Indexed views can be created in any edition of SQL Server 2000....

You won't have an issue. If you want to compare what the editions have to offer, look up this URL from Microsoft:

http://download.microsoft.com/download/8/1/7/817bb6e6-9d97-4a5d-be8d-508256ae4045/ChoosEd.doc

MSDE (Desktop Engine in 2000 release) has a...