I aggree

Set Transaction Isolation Level Read Uncommitted

is easier than putting (NOLOCK) (without the WITH) after each referenced table in the SELECT STATEMENT.

But always be aware if a tansaction fails...

May be this http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q281517

Use the diagrammer in SQL Server. Pick your tables and do a custom view of the items. This will give you a nice view of the table and you can...

Can you please post the TRIGGER in full including it's CREATE statement and any triggers that run for UPDATES.

Personal Opinions here.

Make B the development sever, the reason being you want the box that will so the greatest design deffects the slower procs and this also forces them to...

It is called a pivot table and the problem you have is there is nothing to define which item will be SKU1, SKU2 and SKU3. Your best bet is to...

First and foremost. Your DBA has the sole responsibility for keeping things up and running. You take his abilities to troubleshoot away you are essentially asking them to make sure...

Actually even with using the column names themselves I have found when people use Em to add columns in the middle of an existing table that the views remember the...

This is one of many ways to do it. Very simplified and really depends on the overall use and palnned implementation as to what is the best way to handle.

Either...

It should only evaluate to the first true condition in an OR chain.

MOM worked well for us but did have a few issues with network traffic on it which was solved by adjusting some of the things it monitored. Ultimately though we...

Although I believe there are pratical impacts on defragging the servers file system I do suggest only do when you have CPU cycles you can spare and be aware if...

Anythime you make a change to an underlying table for a view yuo should do that to force it to rebuild the dependencies right.

You sould also look in BOL at...

Additionally you should always simplify the CASE statement if possible.

For both situations you return the same thing

dbo.F_VEHICLE_STATUS.VEHICLE_STATUS_UNITS

So instead of a CASE WHEN...ELSE CASE WHEN... or doing CASE WHEN...WHEN...ELSE try this

sum(case...

I thought Yukon was going to come in 32 bit and 64 bit flavors as most companies will not have adopted 64 bit by it's release. 64 bit cpu's are...