Also, is this a transactional system or a BI system? 60 columns for some of the BI systems I've seen is pretty standard.

Vijaya Kadiyala (1/8/2009)

---

Merge Join :

SQL Server performs a join between two sets of row data using the merge

join algorithm. The inputs are two separate sets of row data. Output...

Something I hadn't thought of earlier, but you might check the ANSI settings on the connection string from Access. If you use the ANSI standard settings, performance should be fine,...

Ah, then it's not going to be solved by tweaking indexes and messing with the execution plan. Something is going on in the network or with the Access app.

I don't see the execution plan...

jonathan allen (1/8/2009)

---

SELECT OrgID ,

OrgName

FROM Organisation

ORDER BY OrgName

Clustered Index Scan on Primary Key - 95%

Sort (on Indexed OrgName...

The execution plan is your friend.

That will tell you what's occurring within the query.

I would put the customer information in a common table. 40 customers = 40 tables, with 40 different queries and 40 different indexes and 40 different maintenance plans... Oh, and...

Well, there are no guarantees, but I'd say, it depends on what your script is doing. Your standard, every day, every second, script that's updating a set of tables... it...

I agree with Peso.

Think about it. First, you'd need 365 seperate tables for just one year worth of data. Second, your queries would have to be changed, every single day,...

I've got SQL Server 2000, 2005 and 2008 running on one machine along with three different copies of Express. All with no issues.

My understanding is that you can install Management...

From what you've laid out, it sounds OK. Usually, when dealing with a many-to-many table like this, I let the foreign keys also define the primary key. Otherwise you need...

If the errors you hit result in a disconnection from SQL Server, there's nothing that can be done to catch or handle those errors. As for the rest, look up...

I don't understand either.

Can you show what you've tried that hasn't worked?

It sounds like you need to get rid of the cursor and just run a query using the data in a join or possibly as part of the where clause.