Yes you will need a license for that.  That said, get into a relationship with your licensing rep and get anything they say in writing.

Thanks Jeff and John for the help.  I ended up rewriting the vw_pos_period_dim as a materialized view.  Still not sure why that worked since the view itself performed well, but...

The trace flag and the hint that I included do the same thing for the cardinality estimator.  I agree the real solution is to adjust the query to fit the...

You can use sql Profiler to watch for linked server traffic. Just filter the loginName column by whatever linked servers you are looking for.  In the Events Selection, be sure...

Thanks for all the replies.  This scenario did cause deadlocks on the service, I just need to learn how to read dateTime correctly when reading the logs.

I ran into a similar error.

NULL

Starting copy...

SQLState = 01000, NativeError = 0

Warning = [Microsoft][SQL Native Client][SQL Server]Aug 6 2009 12:10PM

SQLState = S1000, NativeError = 0

Error = [Microsoft][SQL Native Client]Unable...