If your security setup allows it, you can also make sure your local drives are "shared" by the Citrix connection and select a local drive to export to.

If you would provide the code you are using for the export to Excel, that would be of great help in answering your question.

Also, have you considered doing this in...

Based on the limitations you mentioned, I would suggest the following:

1. Create another database on the server to hold data you do not want to risk being deleted during vendor...

The best way to do this is to have a scheduled job that runs your dbcc command. It should include success testing and write the results to a logging...

Transact-SQL is a linear language and as far as I know every line must be complete before the next line is executed.

Includes in an index typical reference columns that cannot be part of the index itself such as bit columns. The includes also enable an index with more than the...

Please clarify the scenario. Are you saying that ODE will sometimes never apply, or that ODE may not always be paired with the other data?

If you only get one...

If they send you the original PDF, and it is not locked, you should be able to edit it and add the database link and binding.

You will need Adobe Acrobat,...

Steve,

I am still thinking that the issue is your NULL values. You only used the date in your example which means your WHERE clause

where V2.FieldDate = @FieldDate ...

Sorry, made a post before I realized I was only on the first page of posts.

How large are the image files? Varbinary(MAX) has a size limit of 2GB.

The easiest way to load is via ADO.NET. There are several examples on how to do...

Eval editions have typically been hard coded with the "time bomb" code. For every eval edition I have ever used, including SQL Server, uninstall before installing a live version...

That is correct.

I suspect that all of the parameter values are not being filled in or you have tried to customize the parameters in SSRS.

One issue I see is that you have...

I think normalizing is your least costly fix to the performance issue. Taking the time up front to do the database right will save more time than you could...