I'll defer to Gail on this, but CXPacket is the top wait type so I'd definitely look at what is getting parallelized and perhaps modify the Threshold for Parallelism setting....

Are you backing up to a local drive or a network location? Sometimes this happens when backing up across a network you can get these issues.

Can you post the .NET code or at least a similar example? I'm really not sure what you mean.

I'm not sure what you mean by a .NET database. ...

Are you seeing any CXPacket waits? I'm wondering if the upgrade has caused more parallel processing and this is causing issues?

Steve Jones - SSC Editor (10/21/2011)

---

Not...

Grant Fritchey (10/21/2011)

---

Throw out an old...

Brandie Tarvin (10/21/2011)

---

What sort of presentations...

No worries. We all forget the little things sometimes. That's why code reviews are so important, they catch the little things we can miss.

Did you add the parameter to the dataset query? THen you need to assign the report Parameter to the query parameter.

I'm not sure why you need the tax table. There is no relationship between inventory and tax without the taxapplies table, so the simple query I provided would show...

On a more serious note, I'd like to put together a new presentation, but I'm a bit short on ideas. Any suggestions?

Holy crap! Is that SNOW already? I was thinking...

What is the data type in the table? SmallDateTime's precision is to the minute and it rounds. See BOL here.

The only other time I've seen an issue where a log file couldn't be found, and in this case it was the only log file, was when the location was...

Brandie Tarvin (10/20/2011)

---

Brandie Tarvin (10/20/2011)

---

Jack Corbett (10/20/2011)

---

The only time I've seen this is with tempdb and a SQL Server Service restart fixes that.

A restart might fix this as well....