It would be easier to answer if you provided the tables, the relationships between them, and what data you are going to return.

I haven't been in on many sessions yet.

Jason, can you get to Tom Larock's Ustream? You can at least hear the sessions.

I know the SQL Share guys quite well and they are definitely better than the Microsoft course you'll get at New Horizons.

User Groups and SQLSaturday's are good as well.

Here are a couple of CSS SQL Server engineer blog posts that talk about how and why the databases are frozen:

http://blogs.msdn.com/psssql/archive/2008/01/28/how-it-works-sql-server-backup-buffer-exchange-a-vdi-focus.aspx

http://blogs.msdn.com/psssql/archive/2009/03/03/how-it-works-sql-server-vdi-vss-backup-resources.aspx

T-SQL is not the best solution for this. You could write a .NET program that reads the paths from the database and moves the images or you could do...

The only way I know to clear it is to restart the SQL Server Service.

Quiet in here today. Everyone at 24 HOP?

Can you post table definitions and some sample data? I'd like to play with a couple of things.

All right, had you said Report Builder I think you would have gotten more responses. I have not used Report Builder or report models yet, so I don't have...

Ditto for posting the actual plan.

Also, you may want to use the OPTION (MaxDOP 1) query hint because it is unlikely you need parallelism on this query and that

could...

Actually I made several changes. The...

You might be better of taking the values in your in clause and putting them in a table with an index and then join on them because the IN gets...

Can you define what you mean by "dynamic report"?

The answer is, It depends.

Moving the report server to another server should make more resources on your SAP server, but if your performance issues are due to poor queries or...

I think this is what you need:

SELECT

dbo.PURCHASE_ORDER.VENDOR_ID,

dbo.VENDOR.NAME,

dbo.PURCHASE_ORDER.ID,

dbo.PURC_ORDER_LINE.LINE_NO,

...