cfradenburg (7/22/2011)

If you can create the temp table outside the dynamic SQL you can reference it inside....

Thanks for the responses.. a little more detail.

I'm not actually using the ##temp tables, I have a client and I asked him why did he want to use them instead...

I have a love/hate view on the 'cloud' As developers/dbas/'as other duties assigned' employees, we all know the cloud is just a fancy word for internet based services -- and...

thanks for the feedback on this.

--now let me throw in the curve ball, as i said originally the table doesn't even have a clustered index, just a uninque non...

If you have a clustered index where the clustering key is unique, narrow, static, and ever increasing (eg, an identity column or some naturally static increasing key) then it can...

Thanks for both responses so far.

I still haven't had time to read any BOL on the subject but I will tomorrow.

I was looking for more of a performance information when...

oops i meant that sql server was running as local system account and i was in the local admin group.

i moved the master once, and i followed the instructions from...

running under local admin -- i know.. but client says do it.

but sql server is fine.. i was not able to browse the harddisk until i took all those steps...

What books do yall recommend on this topic?

Also, fragmentation aside. I have two tables that are the same in structure and data (imported exactly the same).

One has a clustered...

i've googled bol and it's not helpful. any books i could buy on this topic that you guys recommend?

thanks

Thanks John that makes sense.

On the fragmentation issue - if i never ever do updates or deletes (this is an archive table and loaded incrementally daily), what type of fragementation...

Thanks for responding... So most of the time we say put a clustered index on a table for the sake of having one. So I used a 'natural key'...

Hello,

I know this is an old post, and i've done some research in BOL and other websites, but no where can I find an answer to this question. I...

Thanks to all for responding so fast. I talked to the supplier of the file and they made the file adjustments with no problem 😀

Like I said earlier, I...

thanks i am going to test that today