I'm not sure why you do the convert(int, '2') instead of just 2, but if you are setting a constant you can just use the constant in your join. ...

I think this almost works although for me week 18 would be 5/4-5/10. How do you know that week 18 is 4/27-5/3?

[font="Courier New"]SELECT

   DATEADD(week, 18, '1/1/2008') AS date,...

Replace your problem code and the delete that follows it with the code I provided.

Sounds like you have a really huge number on your hands then, or you have some non-numeric data in that column. I'd usually try to break the problem down...

It might help if you told us what the error is. Also why don't you just rename the file:

Dim oFile

oFile = FSO.GetFile(CopyFromSpec)

oFile.Name = CopyToSpec

That's why I'm wondering about fragmentation. If the index is fragmented then seeking is making you jump all over the place in the chain whereas scanning is running as...

Duplicate post. There are more answers here: http://www.sqlservercentral.com/Forums/Topic548448-146-1.aspx

Your cache ratio is low. So finding out why SQL Server is not grabbing more memory will help as it appears you have is available, but if you are...

Sorry I did not see the first post wher you ask the best way to post the Execution plans. My preference is to save the graphical execution plan in...

You are going to have to do some interesting work to get this up because the Datetime datatype starts at 1/1/1753. Here is how I think you need to...

1.9 is being used and there is 3 being available.

I'm not sure the issue is the amount of RAM as you are not using all that is available. You have 5gb available to the server and SQL is...

You need to include the ApplicationName column in your output and then you can set a filter on that column for your application name. Of course in order for...

Target Server memory is the max SQL Server will consume.

Total Server Memory is the amount that SQL Server IS using.

Are you running 32-bit or 64-bit? If you are running...

Post the execution plans, I'd be interested in seeing how SQL Server is pulling this off!