Depending on how wide the table is, a nonclustered index on id...

Pablo Campanini-336244 (8/16/2012)

---

WOWWWWWW....

Listen to this....

Yes I can not see the tables thru SSMS when I am logged in as U1,

BUT if I do a select on the tables with schema...

sturner (8/16/2012)

---

roger.plowman (8/16/2012)

---

Much of my objection to C comes from the sheer grunt work of memory management. C is notorious for memory leaks and buffer overflows. While VB dialects before...

Again, it isn't the questions nor the answers that are getting worse, it is the people asking the questions.

I swear (especially when behind the wheel of a car) that the...

Here is the problem we face, we can't see what you see. You are using a temporary table, great. Are you exporting directly from the table using a...

sturner (8/16/2012)

---

Alex Gay (8/16/2012)

---

I wouldn't recommend C as a starting language, but once you can program it is always good to learn what your compiler is doing behind the scenes,...

Have you tried using the Import/Export wizard?

Really having a problem here. I followed your steps and I don't have a problem connecting with the user U1 and I see the table in the Common schema...

What do the reporting options for success say, how are they set?

You could say this is one of those things you won't know is broke until a critical piece of data is duplicated or dropped.

It neither helps nor hinders. It simply the same as using the READ UNCOMMITTED isolation level. IF there is any activity that could potentially cause a duplicate record...

My opinion, "Best" is subjective. What may be best for you may not be best for others, even in the same...

The NOLOCK hint is NOT a go faster button. Personally, I'd remove them.

SQL_ME_RICH (8/15/2012)

---

I was just going to ask about tweaks (as in this current form it is really slow and the database is in Full Recovery mode, so I do not...

Ask a vague question you are going to get a vague answer. 🙂