What does won't work mean? You cannot connect, there is an error? Details are important.

In my opinion, if you do not need to use any of the new features in 2008, I'd stick without the upgrade for now. You do realize that unless...

I believe SSMS is using your windows credentials to browse to the folder, so it would be your credentials that do not have access to the folder. I could...

Without seeing the report definition it is very difficult to determine the issue. If SQL Server is returning the data correctly and you have no calculations in the report...

You cannot create server level roles. Maybe a flaw in the security design. I suppose you could do it by creating a role in model.

dpages is the number of 8K data pages the index uses.

You also do not need to include RowNum in the first non-clustered index because the Clustered index key is included...

I agree with Gail, I don't see anything in the trigger itself that would cause an error and with her comment about the trigger not handling a batch/set-based insert.

Ownership chaining...

Go to the Advanced Tab in the Lookup Transformation Editor and check "Enable Memory Restriction", check "Modify the SQL Statement", and click the Parameters button to map your parameters. ...

The first thing you need to determine is if the performance issue is the rendering of the report or the retrieving of data.

If it is the rendering of...

I guess I've been fortunate to have not had an "Eric" in any departments I've worked in, unless I was the "Eric" and didn't know it. I have had...

Based on some of Jeff's other posts, he is pretty busy with work right now, so mainly...

Size and system activity really do matter in this case. Updating/deleting millions of rows while the database is in use is probably not the best idea while batching it...

I vaguely recall this article as well. I think performance wise they are similar.

It will be very difficult to improve the performance of this query as you are using 2 poor-performing items, a cursor and a linked server.

One thing that I...

Jeff Moden (9/24/2008)

---

Folks, please... go back and look at the original post... the queries are identical except for the IF and the WHERE... just move the IF to the WHERE...