I'd say, just as important as the technical side, is communication skills. If you do get the job, you'll be dealing with big, important clients. They generally call PFEs in...

Depends on what you mean by 'failure'

Database corruption is dealt with very differently to 'I accidentally dropped the database' which is dealt with very differently from 'We've just had a...

I'm guessing it's Microsoft. Premier Field Engineer is part of their premier...

Original, mostly. It's 3d graphics. Some of the models were purchased or free...

In that case I'll amend my index advice

CREATE NONCLUSTERED INDEX idx_TRNDTLSPR09_WKENDDT

ON [TRN].[TRNDTL_SPR09] ([WK_END_DT],[TRANS_ID],[SKU_NUM])

INCLUDE ([SLS_UNITS])

and drop the index that's just on WK_END_DT

I'm sorry, but it's enough work to create one image.

There are a couple nasty table scans in there. Can you add this index and then post the revised execution plan?

CREATE NONCLUSTERED INDEX idx_TRNDTLSPR09_WKENDDT

ON [TRN].[TRNDTL_SPR09] ([WK_END_DT])

INCLUDE...

Merry Christmas everyone.

Since I didn't manage to finish the christmas scene for this year, have one from a couple years back.

No need. The data in an ntext column is unicode (which is what the N prefix means). When you inserted the varchar data, SQL would have done an implicit conversion,...

Couple things...

Do you know that the Statement_History table has no clustered index?

Consider a nonclustered index on the Accounts table on the Account_Type_ID column. There's a clustered index (read table) scan...

That's an awful lot of code. Do some analysis yourself and find where the slow portions of that procedure are, then post those. Also, please post table definitions, index definitions...

You're not referring to the table that you're updating anywhere in the EXISTS so if that subquery returns any rows at all, all rows of the table that's being updated...

First thing, move the SQL into a stored procedure and call that procedure from your ASP (that's classic ASP?)

Once you've done that, please post the proc, table definitions, index definitions...

I don't think he is. Look at the arrow leading towards the Compute Scalar (2nd last operator). Estimated...

You can start with this series on indexes, it may help

http://www.sqlservercentral.com/articles/Indexing/68439/

If you have queries often filtering on two columns then you really should add an index on those two columns....