What are you trying to do with the query? That might help us recommend a view or a stored procedure.

There is relatively little overhead, and as the number of rows grows, the overhead becomes less of an issue. You basically calculate the index size of one row, using data...

I'll have to check on the spell check feature.

This feature should be working. My guess it's an intermittent error or that the file is bad. Please ask the person to resend it.

Didn't test it, and perhaps there are none. In any case, I think it's been a nice debate/discussion of the technique.

Identities alone shouldn't cause Access issues.

However, I can see issues with your trigger when you update multiple rows. That would cause issues.

I didn't think it was a good design, and not sure it really saved space, but I knew it would generate discussion. Lots of people, especially developers, think this way....

There is a NYC group run by Joe Lax.

http://nycsqlusergroup.com/default.aspx

Philly and New Jersey (http://njsql.org/Default.aspx) have groups as well.

Office 2000-2003 formats should work, but a jpg/gif/png would be better.

However, there is nothing in that image that provides information. It's a shot of Configuration Manager that doesn't even show...

You'd have to check each database (sysusers) and join back to syslogins.

ms_foreachdb will help you.

GSquared is speechless? And so am I after that.

You shouldn't need admin. Local Service, Network Service, or a domain user account with minimal rights is recommended.

are you changing the service account with the SQL Configuration Manager or just...

I would suggest the default trace as well. There's an article here to help:

http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

It looks like you're comparing dates in a function of sorts. That can be slow. If you can calculate those dates out for a query and store them in variables...

Honestly I think you're on your way, but to tackle more types of issues, do what you just did. Post on forums, or answer questions. Solve other people's issues. Tackle...