Forum Replies Created

Viewing 15 posts - 1 through 15 (of 42 total)

  • RE: Computed Columns 1

    This is what MSDN says (http://msdn.microsoft.com/en-us/library/ms191250.aspx):

    A computed column is computed from an expression that can use other columns in the same table. The expression can be a noncomputed column name,...

  • RE: Subtle Line Feed / Carriage Return issue

    Of course I got it wrong as probably all others trying this question. And it does not matter if you try to answer with or without SSMS.

    QotD should try to...

  • RE: SELECT TOP

    BOL (http://msdn.microsoft.com/en-us/library/ms189463.aspx) states clearly

    If the query has no ORDER BY clause, the order of the rows is arbitrary.

    hence putting "Ann" as the correct answer is simply wrong.

    Nevertheless, using...

  • RE: Unique constraint on a nullable column

    Adding a WHERE clause is no option for two reasons:

    1) It only works for INSERT...SELECT...WHERE... statements. If INSERT...(<field list>)VALUES(<value list>) is used, the WHERE clause is not available.

    2) INSERT...SELECT...WHERE... may...

  • RE: Transactions

    Hi,

    I tried by typing everything in. I can get nothing but the error message "[font="Courier New"]invalid object name 'dbo.items'[/font]". 🙁

  • RE: Basic

    Oh what a shortsighted question! 🙁

    ASCII is a US only standard, hardly usable anywhere else. Ever thought about Europe? Do you really think the French, German, Scandinavian, Czech, Slovak, Slovene,...

  • RE: More fun with ISNUMERIC()

    BOL simply state

    ISNUMERIC returns 1 for some characters that are not numbers, such as plus (+), minus (-), and valid currency symbols such as the dollar sign ($). For...

  • RE: SSMS - feature

    Paul White NZ (3/30/2010)


    Dietmar Weickert (3/30/2010)


    Does not work as described.

    Personally I do not like questions where the correctness of your answer changes with your luck.

    Read the other posts here.

    Still you...

  • RE: SSMS - feature

    Does not work as described.

    Personally I do not like questions where the correctness of your answer changes with your luck.

  • RE: SARGable

    Steve Jones - Editor (2/26/2010)


    The answers have been edited to include the column and "none of the above" has been changed. I will award back points. My apologies as I...

  • RE: SARGable

    Once again a crap QotD.

  • A missing column name a typo? Hard to believe.
  • No info about indices on the table/view to be queried? Who could potentially know about SARGable operators. And...

  • RE: Numeric or Not Numeric

    kaspencer (2/22/2010)


    Good question. And it also raises a further point in my mind ...

    Is there a need to standardise numerical representation across every locale ?

    I ask this because, in...

  • RE: Safety in Numbers

    Hi,

    We keep daily full backups for four weeks, and take log backups every 15 minutes which are stored for the current and the previous day. Everything is stored on (slightly)...

  • RE: Rowcount

    I would add to kaspencer's statement, the following addition: test, test and test again your proposed submission before submitting. Let a few days pass and retest, retest...

  • RE: Database Size

    Hi,

    I have two instances of SQL Server 2005 on the same W2K3 machine, and at least I myself never played around with the model database. (And it is unlikely someone...

  • Viewing 15 posts - 1 through 15 (of 42 total)