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...

Thanks. I've added those items to my original post. There is only one defined index outside of the clustered primary key which is defined as an identity. I know woefully...