Have you tried compiling the project to an ade file for end-users? (Access Help has instructions on how to do this.)

If you do that, you can hide the tables,...

Actually, a read-only database might do just fine on RAID-5, since the problem with RAID-5 is the small, frequent writes that OLTP databases do. Log files for read-only databases...

What are the bitwise operators in there for? What rule are they enforcing?

I don't think you can specifically set "not a remote machine". What you can do is make sure that various logins don't have the rights to execute the system...

Yes, you can do the "insert this table first to get the IDs" thing.

Insert into a table, select from it, join it to the data you inserted from. Voila!...

Loner (7/4/2008)

---

To G^2 - a degree is very different from a certification. Getting a degree, you have to go to college, taking classes, for master and PHD, you need...

Hugo Kornelis (7/8/2008)

---

GSquared (7/8/2008)

---

Just to test this, I tried the following on a table with just over 1-million rows of data:

(...)

I had used fast_forward in the past, based on what...

davidthegray (7/8/2008)

---

Thanks for the answers to my question. Looks like in my db I have 23, among sp's and triggers, using cursors, all written several years ago, which makes about...

Just to test this, I tried the following on a table with just over 1-million rows of data:

declare @Start datetime

select @start = getdate()

declare Test cursor local static for

select col1

from dbo.table1

declare...

I have some thoughts on this.

Are there rules on which items can be comibined with which other items? Like:

A and B

B and C

A and B and C

but not

A and...

ApexSQL Doc

I tried some tests on this. Not sure why the Order By is adding so much time to it, but it sure is.

Best I can suggest is pre-calculate the...

Set up the security so nobody has access to that feature.

When "benefit > cost", is when it's good enough. Judging that is the trick.

I like to operate on lots of small, incremental improvements, rather than huge, monolithic releases. ...

Adding the Exists command seems to me to be unnecessary in any case. Will it actually resolve the lack of such rows more efficiently than the Delete command will...