We changed a lot of things at once when we upgraded, but definitely we're seeing the benefit of 8 processors. From MS presentations I've seen, they expect to scale almost...

I've had mixed results with the tuning wizard. A good start is to get a primary key on each table. Next would be to index columns that are foreign keys...

Not sure how much overhead there is to letting SQL manage the memory. I'll look to see what I can find. As far as your proposed solution SQL will still...

Never seen that. Maybe try unregister/reregister the server?

Andy

Nope, just change the suid. In SQL7/2K you could use sp_change_users_login, not sure if it exists in 6.5.

Andy

Steve can probably help more than I can - Im trying to forget 6.5 ever existed! In 7/2k you'd run into this if you had an "orphaned" user. Might try...

You'll use Perfmon to see all the different counters. For memory, I generally look at SQL Buffer Cache Hit Ratio - should be above 90%. You're right that there is...

I dont see a convert style that would do it, probably the closest is 101 - which would return mm/dd/yyyy. Seems like there should be something better, but this should...

I dont think we have anything on the site yet - try this article from MS:

http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q258038

It's pretty straightforward. Note that if you're doing ASP work, the Response object supports the...

If you're concerned about mem usage, why not change to fixed mode? Im not sure that what is happening is bad or wrong - natural for SQL to take memory...

Space information gets calculated when you need it - run sp_spaceused. Sysusers will hold the valid users for a db - they have an ID that maps to a login...

Could you run select @@version and post just to be sure?

Andy

Are you running the personal edition? Or MSDE? I saw a couple newsgroup postings that indicated this is the probable cause of the problem.

Andy

Im surprised this would happen, but I dont use object ownership, so wouldnt have noticed if it did! Seems like you should be able to change the object owner on...

Assuming you have all the required ports open, yes, you could probably do it. Just use a sql login for security.

Andy