Forum Replies Created

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

  • RE: Premature casting on 0 rows insert

    siggemannen (2/28/2015)

    Hello,

    I have encountered some weird behaviour. Code that has been working for "eternities" suddenly started to fail.

    Alas, i couldn't recreate it on any other machines.

    I'm afraid that this is...

    March 1, 2015 at 4:59 am

    #1780941

  • 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...

    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...

    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...

    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...

    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

    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...

    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...

    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...

    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...

    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...

    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....

    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...

    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...

    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...

    February 18, 2015 at 12:23 pm

    #1778450

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