Forum Replies Created

Viewing 9 posts - 1 through 9 (of 9 total)

  • RE: Answers to Your QOD

    The submitter is responsible. It is NOT MY RESPONSIBILITY to review their work. How lazy and weasely is that. Try telling your users it's their job to...

  • RE: T-SQL

    I actually HAVE submitted a QOTD and was trounced for inaccurate wording. In this case, however, the answer to the question asked is FALSE. It's been shown multiple...

  • RE: Database defintion from an Excel Spec?

    I was basing the 10K on the 80 hours estimated in the article @ $100 /hour plus a few hours of debugging, tweaking etc.

  • RE: Database defintion from an Excel Spec?

    That's a good workaround but there are modeling tools available that will build a database, logical and physical models from a spreadsheet. Then again, some of the contractors I...

  • RE: EAV Model

    It's also known as a "Stuff" table. All the company's stuff is thrown into 1 table. It ensures that performance is dismal and is a great method to...

  • RE: UNIONS

    silly question but do you want to remove duplicate counts that occur in the same time period? Union and Union All may have different answers depending on your data

    create...

  • RE: why is my sql box not using all 16GB????

    Operating system? Patch level?

  • RE: one character of data

    I agree, varchar(1) is not a good answer because of the extra 2 bytes of storage. For the smallest I would chose char, for multibyte languages, Nchar. Your...

  • RE: T SQL

    Like everyone else seems to have, i discarded the first answer because there was NOT a second name in the third row. Yes I understand it's a typo...

Viewing 9 posts - 1 through 9 (of 9 total)