Forum Replies Created

Viewing 15 posts - 136 through 150 (of 294 total)

  • RE: Updating ID field

    Solution found -

    SET IDENTITY_INSERT [FIM_GLOBAL_ID] OFF

    drop the row I want to change the ID on and then re insert it with the new ID

    SET IDENTITY_INSERT dbo.[FIM_GLOBAL_ID] ON

    November 11, 2013 at 9:28 pm

    #1665633

  • RE: Using Max()

    Very good question - got caught out with as well. Should have realized that with out the where clause that each max() is evaluated individually... nice to learn something at...

    November 7, 2013 at 10:50 pm

    #1664996

  • RE: COUNT, COALESCE, ISNULL, DISTINCT

    raulggonzalez (11/7/2013)

    Thanks for the question!

    Considering that it states "choose 3 answers" and there was no name "JAMES", for me was pretty clear that the author assumed a case insensitive scenario.

    +1...

    November 7, 2013 at 7:13 pm

    #1664983

  • RE: Compressing Filestream

    Thanks for the QotD.

    November 5, 2013 at 9:11 pm

    #1664319

  • RE: UNION

    L' Eomot Inversé (11/5/2013)

    Ford Fairlane (11/4/2013)

    Richard Warr (11/4/2013)

    Seems to be one where the people who didn't think about it found it easy (see some of the comments above) whilst those...

    November 5, 2013 at 4:33 pm

    #1664281

  • RE: SQLCMD

    😀 Easy question - no wait after looking deeper into this shouldn't I expect to see oh wait no it was easy thanks Steve for the QotD

    November 4, 2013 at 8:49 pm

    #1664023

  • RE: UNION

    Richard Warr (11/4/2013)

    Seems to be one where the people who didn't think about it found it easy (see some of the comments above) whilst those who dug a bit deeper...

    November 4, 2013 at 5:20 pm

    #1664005

  • RE: UNION

    Too easy and straight forward QotD. 🙂

    November 3, 2013 at 5:37 pm

    #1663706

  • RE: "NOT IN" Operator and Three Valued Logic

    Rune Bivrin (11/1/2013)

    Well, good question, but the correct alternative was a bit misleading. You don't get a zero back, you get an empty result set. That's a different answer.

    The man...

    November 1, 2013 at 1:52 am

    #1663356

  • RE: "NOT IN" Operator and Three Valued Logic

    Great QotD - made me think and slow down before answering ( also ran the code to check what I thought MAY be the answer )

    November 1, 2013 at 1:03 am

    #1663344

  • RE: DATE Conversion and Format

    Nice QotD thanks

    October 30, 2013 at 1:45 am

    #1662624

  • RE: Nested Transactions

    Nice start to the week.

    October 27, 2013 at 9:27 pm

    #1661839

  • RE: SQL Server 2012 service accounts

    Thanks for the easy way to end my week 🙂

    October 24, 2013 at 10:59 pm

    #1661515

  • RE: CDC

    Koen Verbeeck (10/23/2013)

    Easiest question ever. It doesn't even matter which feature is being asked.

    Enterprise has every feature, and developer & evaluation have the same features as Enterprise.

    Ergo, no thinking needed,...

    October 23, 2013 at 11:43 pm

    #1661142

  • RE: Date Functions

    Nice question - thanks

    October 23, 2013 at 11:40 pm

    #1661141

Viewing 15 posts - 136 through 150 (of 294 total)