If I join the #Tmp2 table sql directly to #Tmp1 then I am back to poor performance... + 1 hour instead of < 1 second. I understand that an index...

GSquared,

First, I don't have a proc... I created the sql while trying to troubleshoot the issue with the query. I am not trying to change an existing proc but replace...

Jack,

Thanks for the quick reply.

Sorry about not including the .sqlplan version, I was hoping that the text would be enough. It took me a while to rename the tables...

Again, in SQL 2005, so unless you are planning to upgrade this isn't much help, but I am thinking a database snapshot might suffice. The initial snapshot is based on...

Start with BOL (Books online). It covers a basic what's what. If you are learning to learn, they have easy to follow walk-throughs... though you may need to download an...

I would try to "recompile" the JPeg image. Open it in a good editor (Photoshop, Paint Shop Pro, etc) and "convert" or export it into a JPeg once again. Play...

I had / have a similar problem with connections to DB2 (from SQL 2K5). If a specific error occurs on the DB2, the specific piece bombs, but SQL Server does...

No problem!

I do not have the link that I used to download it. You can either google it, or search Microsoft for a downloadable version, or send me an email and...

There is an executable, "WaitFor.exe", that will either wait until a specific string is sent or until a time out (where it will error) or send a string. If you...

Again, just trying to clarify:

ServerA has SQL Server. ServerB does not(?) You want to run a command line on ServerB after ServerA finishes restoring a database. Is this correct?

I don't have time to work on this... at least I won't for a while, but since the data is stored as XML (with nodes that can be translated to...

I use a calendar table for something similar. I have a list of dates and certain values (Fiscal Year, Fiscal Qtr, Fiscal Month, Fiscal Week) for each date. The calculations...

Eric, do you have only one macro per workbook that you need to run? It has been a while (office... um 95? Maybe?) , but you used to be able...

I am not sure exactly what you are after, but if you have network permissions for your SQL Agent account then you can create a SQL Server Job that runs...