Forum Replies Created

Viewing 15 posts - 1,921 through 1,935 (of 7,483 total)

  • RE: How to calculate Difference

    SwePeso (3/1/2015)

    Be very careful with LAG here. If you for some reason don't have data for the previous measure period, you will get the measure period before that.

    That's why why...

    Tom

    March 1, 2015 at 3:54 am

    #1780937

  • RE: XML Indexes

    Nice and easy question. Pity it's about XML :(.

    If one of the options had been primary, path, content and value I would probably have tossed a coin to choose...

    Tom

    March 1, 2015 at 3:19 am

    #1780934

  • RE: Maximum number of databases per instance

    Nakul Vachhrajani (2/27/2015)

    Easy one.

    What's interesting is that 32767 is the upper limit for SMALLINT (2-byte/16-bit integers). Yet, the database identifier has a data-type of INT, not SMALLINT. I guess...

    Tom

    March 1, 2015 at 3:11 am

    #1780933

  • RE: What is the equivalent to Yes/No data type in SQL?

    Jeff Moden (2/28/2015)

    kennethrinderhagen (2/27/2015)

    Yes/NoA logical field can be displayed as Yes/No, True/False, or On/Off. In code, use the constants True and False (equivalent to -1 and 0). Note: Null values...

    Tom

    February 28, 2015 at 2:47 pm

    #1780904

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/26/2015)

    ... Mark one off, 1 day on the calendar to go. 1 day on the calendar to go, 1 day to go, ...

    Safe landings, Lynn

    Tom

    February 27, 2015 at 9:41 am

    #1780668

  • RE: The answer to life, the universe and prime numbers

    Shadab Shah (2/26/2015)

    So Experts, which is the correct explanation. Either given by Eirikur Eiriksson or Toreador.

    The one given by Toreador. The implicit conversion from -51 to varchar(1) discovers that...

    Tom

    February 26, 2015 at 12:57 pm

    #1780378

  • RE: Today's Random Word!

    Ed Wagner (2/25/2015)

    djj (2/25/2015)

    SQLRNNR (2/25/2015)

    Ed Wagner (2/25/2015)

    djj (2/25/2015)

    Ed Wagner (2/25/2015)

    laurie-789651 (2/25/2015)

    Stuart Davies (2/25/2015)

    SQLRNNR (2/25/2015)

    Ed Wagner (2/25/2015)

    BWFC (2/25/2015)

    Ed Wagner (2/25/2015)

    laurie-789651 (2/25/2015)

    Ed Wagner (2/25/2015)

    djj (2/25/2015)

    Ed Wagner (2/24/2015)

    SQLRNNR (2/24/2015)

    four

    Square

    Cube

    Dimension

    Declare

    Decree

    Absolute

    Resolute

    Desk

    Raven (obtuse - I know)

    Dun

    Finish

    Good...

    Tom

    February 25, 2015 at 4:40 pm

    #1780090

  • RE: Drop Database

    sipas (2/24/2015)

    The second answer couldn't have been correct as there's no such thing as an ohysical file 😀 - although it must be a common typo as Google gives 107,000...

    Tom

    February 24, 2015 at 8:36 am

    #1779609

  • RE: PK v Unique Index

    I think that there are only three points that need to be got over to people on this topic:

    (a) a nonclustered primary key and a non-clustered unique index where the...

    Tom

    February 21, 2015 at 10:00 am

    #1779121

  • RE: Today's Random Word!

    Ed Wagner (2/20/2015)

    crookj (2/20/2015)

    Ed Wagner (2/20/2015)

    djj (2/20/2015)

    Ed Wagner (2/20/2015)

    SQLRNNR (2/20/2015)

    Ed Wagner (2/20/2015)

    crookj (2/20/2015)

    SQLRNNR (2/20/2015)

    Ed Wagner (2/18/2015)

    SQLRNNR (2/18/2015)

    Ed Wagner (2/18/2015)

    Revenant (2/18/2015)

    SQLRNNR (2/18/2015)

    silhouette

    Harlequin

    Romance

    gag (harlequin romance)

    Vomit (I agree)

    thread killer:w00t::w00t::w00t:

    Moth

    Flame (sorry about the near-death...

    Tom

    February 20, 2015 at 8:35 pm

    #1779096

  • RE: PK v Unique Index

    Steve Jones - SSC Editor (2/20/2015)

    I think that there shouldn't be any difference between a PK and unique index, whether CI or NCI, but perhaps there's some misunderstanding out there....

    Tom

    February 20, 2015 at 8:24 pm

    #1779095

  • RE: TDE and In-Memory OLTP

    sestell1 (2/19/2015)

    david.gugg (2/19/2015)

    Wait, so if the memory optimized filegroup is not encrypted, does that mean the data is vulnerable? Should in-memory OLTP tables not be used with sensitive data?

    Encrypted...

    Tom

    February 19, 2015 at 3:02 pm

    #1778788

  • RE: Not Again!

    Nice question. Easy, since 230 is a permission failure error. I'm inclined to agree with the person who suggested this behaviour is a bug (especially for select...

    Tom

    February 19, 2015 at 2:54 pm

    #1778785

  • RE: WHERE 1 = 1,who uses this besides me

    CELKO (2/18/2015)

    I see I am not the only one that remembers how horrible this is in any language.

    Remember it from Assembly languages? If you dropped it, the line count would...

    Tom

    February 18, 2015 at 12:23 pm

    #1778450

  • RE: Today's Random Word!

    Revenant (2/17/2015)

    Ed Wagner (2/17/2015)

    crookj (2/17/2015)

    Ed Wagner (2/17/2015)

    djj (2/17/2015)

    SQLRNNR (2/17/2015)

    hash

    Corn beef

    Cabbage

    sauerkraut

    Brine

    turkey

    thanksgiving

    Tom

    February 17, 2015 at 5:51 pm

    #1778230

Viewing 15 posts - 1,921 through 1,935 (of 7,483 total)