ha ha ha..Thanks Ten Centuries! I appreciate the links and the humor. It helps keep this in perspective 🙂

The dataimport worked fine. At least it got it into sql server for me to work on it. Only one table failed to import but I can work around that....

The database I was sent is from Access 2000. I have Access 2007 on my machine. i guess there are alot of input forms that were apart of it (i...

That is a pretty interesting problem. I actually discovered that I have a similar problem in a db I just acquired so these solutions will come in handy for me...

I didn't know that syntax existed. I'll give it a whirl.

Thanks!!

Actually this is a script we're using to load data from a legacy system into our current system and don't need to store the old varchars. Once we do the...

It's that easy? Wow...I actually guessed right...lol..that doesn't happen very often 🙂

Thanks!

Yes..apparenlty it is working fine. I wasn't aware of the lag in updating the file. now I can read Part 2 of the article 🙂

Thanks everyone!

It's up to 19,968 kb now. Maybe it only write periodically or when it stops running. I had it set for 30 minutes.

Thanks!

It is still at 0kb. I ran through the pages of the site a few times so it should show something for a size. Does it matter that I made...

I moved it to the production server and ran it. It created the trc file in the direcotry as expected but it s 9kb. Will the trc file only be...

Thanks for the reply ps but I'm still not getting it. I've attached my trace file. I have saved it with a .trc file extension. I have it open in...

Thanks for your reply. I suspected that the rushed table construction would come back to haunt us! I've been able to get the execution time form 15 seconds down to...

Perhaps a better question is how can the distinct be removed from the query?

I made some changes to the query and reran it with the stats. i've attached the updated query plan to this post.

I replaced 2 functions in the select with ..don't...