Lynn Pettis (7/10/2009)

---

That's because we don't have the data to see what is going on behind the scenes. I'll wait and see what Luke comes back with on this...

That's because we don't have the data to see what is going on behind the scenes. I'll wait and see what Luke comes back with on this one.

It would help to see the DDL for the base tables (including indexes) and the view. Anything we might do without those would just be shots in the dark.

Please read this article[/url] and follow the guidelines within to post the necessary info so we may better help you with your performance issue.

GSquared (7/10/2009)

---

I've never seen it cause a difference in results. Not with 2k, not with 2k5, not with 2k8.

Not going to say it can't happen, just that I've never...

You can also license SL Server per user, and then it doesn't matter how many processors the server has, just the number of users/devices that are accessing the data. ...

I can't answer your last question, but with regard to licensing of SQL Server, it is based on physical processors (or sockets if you will).

If you have a dual-processor server...

IE 7. I use IE 7 at home with no problems.

Personally, I think it has something to do with the our network or some piece of hardware used on...

Perhaps we should take their approach, and ask Steve to close this thread as well. I do have to admit I liked reading...

I think it really depends on where you want to go career wise. Your choices offer different career paths, one being more system/network related the other Database-centric.

Why are you allowing users to write SQL directly against the database any way? Such access should be through an application or API (such as stored procedures).

Thanks for the feedback.

LeeM (7/10/2009)

---

We have many instances and I have found the following issues:

1. It does use more system resources than one instance: you have two sets of system databases including tempdb...

How about posting the code you are working with and the table structure of your logging table. A little hard to provide good advice when we are basically shooting...

Let us know if it helps.