Viewing 15 posts - 16 through 30 (of 348 total)
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...
June 12, 2009 at 9:53 am
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...
June 12, 2009 at 9:44 am
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...
May 15, 2009 at 7:30 am
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...
May 11, 2009 at 7:29 am
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...
April 24, 2009 at 7:07 am
-- posted out of order, please ignore. It won;t let me delete my response.
April 10, 2009 at 6:08 am
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.
March 12, 2009 at 7:52 am
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...
January 23, 2009 at 7:08 am
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.,...
January 22, 2009 at 7:24 am
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...
January 21, 2009 at 9:10 am
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...
January 21, 2009 at 6:27 am
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,...
January 20, 2009 at 8:13 am
Lowell's suggestion worked beautifully. Thanks.
December 12, 2008 at 7:54 am
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...
December 12, 2008 at 7:33 am
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...
November 14, 2008 at 11:44 am