I got an economics degree as an undergrad, and ended up falling backwards into an IT job (because I bought a computer from the university store that had OS/2 on...

Is this a backend for a 3rd party application, or something your company developed itself (it sounds like a 3rd party app)?

I would be very careful before applying clustered indexes...

I don't think we ever have a truly accurate view of the past - we may feel like we learned faster, retained more, etc. but that's all through the lense...

I'd like a good definition of what a DBA is as well. Or better yet a range of Database related job titles:

DBA - The A stands for Administrator (which implies...

I'm curious about how much overalap there is between this book and The Microsoft Data Warehouse Toolkit (http://www.amazon.com/Microsoft-Data-Warehouse-Toolkit-Microsoft-Business-Intelligence/dp/0471267155/ref=pd_bbs_sr_1?ie=UTF8&s=books&qid=1240578426&sr=8-1).

I have the Microsoft specific one on my desk right now...

-- posted out of order, please ignore. It won;t let me delete my response.

That's an interesting angle - possibly sacrifice some performance for electricity savings.

I'd still probably err on the performance side, but I hadn't really thought about it that way.

I'd...

Congratulations!

I am going to start working on my MCITP: Database Developer (I already have the Admin) now that I've finished my MBA.

I wonder if I'm ever going to...

However, I have read quite a few things about risk analysis in banks and there were lots of people that built models designed to calculate risk, probabilities of default, etc.,...

If my kludge helps, great!

I'd really like to be able to accomplish this trye of thing entirely inside SQL Server (like with a synonyn) instead of relying on having to...

Not sure what you are referencing here, but you can easily create a synonym that accesses an object through a linked server.

Create the linked server, then in the local database...

I really wish you could use synonyms for databases on remote servers. We use SQL Client Aliases to keep from having to change code going from development , to QA,...

Lowell's suggestion worked beautifully. Thanks.

Neither of those choices will allow a user without execute rights to a stored procedure to find it in a listing by querying information_schema.routines or sysobjects.

This is stemming from...

The third choice is still a little ambiguous. From BOL:

Specifies the nonkey columns to be added to the leaf level of the nonclustered index. The nonclustered index can be unique...