Forum Replies Created

Viewing 15 posts - 1,891 through 1,905 (of 7,483 total)

  • RE: Foreign Key Fun

    Hugo Kornelis (3/18/2015)

    TomThomson (3/17/2015)

    Is there a good reason for not supporting cross-database foreign key constraints? For some reaon or other I believe there isn't.

    How would you handle dropping a...

    Tom

    March 19, 2015 at 9:44 am

    #1785115

  • RE: Identity Column Datatype

    Miles Neale (3/18/2015)

    TomThomson (3/17/2015)

    Miles Neale (3/17/2015)

    Nevyn (3/10/2015)

    TomThomson (3/7/2015)

    This is a rather early repeat! We had an identical question on Jan 13th, less than 2 months ago; and then on...

    Tom

    March 18, 2015 at 8:33 pm

    #1784964

  • RE: Columnstore Indexes

    RLilj33 (3/17/2015)

    lcajui (3/17/2015)

    Koen Verbeeck (3/16/2015)

    Can only create nonclustered columnstore index in SQL Server 2012

    This makes it seem like you could only create nonclustered columnstore indexes in SQL 2012, but not...

    Tom

    March 17, 2015 at 8:32 pm

    #1784643

  • RE: Foreign Key Fun

    Hugo Kornelis (3/17/2015)

    From the explanation:

    (there isn't any good reason for this, as the target of the foreign key isn't in a temp table, but for some reason temp tables are...

    Tom

    March 17, 2015 at 8:08 pm

    #1784641

  • RE: Identity Column Datatype

    Miles Neale (3/17/2015)

    Nevyn (3/10/2015)

    TomThomson (3/7/2015)

    This is a rather early repeat! We had an identical question on Jan 13th, less than 2 months ago; and then on Jan 20th we...

    Tom

    March 17, 2015 at 8:01 pm

    #1784640

  • RE: Today's Random Word!

    Revenant (3/17/2015)

    Ed Wagner (3/17/2015)

    Star Trek

    Enterprise

    Overpriced

    Tom

    March 17, 2015 at 7:58 pm

    #1784639

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (3/16/2015)

    Ed Wagner (3/16/2015)

    Brandie Tarvin (3/16/2015)

    Ed Wagner (3/16/2015)

    Brandie Tarvin (3/16/2015)

    So I'm reading my Database Weekly this morning and find a link to Brent Ozar's SQL Rally commentary[/url]. Funny, I...

    Tom

    March 17, 2015 at 1:18 pm

    #1784583

  • RE: Nested Break

    Koen Verbeeck (3/17/2015)

    Easy one and a bit of a déjà vu as well.

    Thanks Steve for the question.

    Yes easy, and yes, very much déjà vu - it's pretty much the same...

    Tom

    March 17, 2015 at 12:32 pm

    #1784574

  • RE: Secondary XML Indexes

    Jeff Moden (3/14/2015)

    Ed Wagner (3/13/2015)

    I must admit that I don't use XML very much. It's does store very flexible data structure, but it just doesn't perform well. Thanks...

    Tom

    March 14, 2015 at 12:26 pm

    #1784053

  • RE: Today's Random Word!

    Revenant (3/13/2015)

    Eirikur Eiriksson (3/13/2015)

    SQLRNNR (3/13/2015)

    jasona.work (3/13/2015)

    Stuart Davies (3/13/2015)

    SQLRNNR (3/12/2015)

    drone

    Bee

    Happy

    shining people

    laughing

    living

    dying

    Tom

    March 14, 2015 at 11:59 am

    #1784049

  • RE: Columnstore Indexes

    Nice simple question.

    After getting the 23rd Feb question wrong because I forgot that 2012 didn't include clustered columnstore I found this one rather easy.

    Tom

    March 14, 2015 at 11:54 am

    #1784047

  • RE: Secondary XML Indexes

    Nice and simple. But I avoid XML like the plague.

    Tom

    March 14, 2015 at 11:47 am

    #1784045

  • RE: Are the posted questions getting worse?

    spaghettidba (3/12/2015)

    rodjkidd (3/10/2015)

    Gianormous (:-) ) was only there Saturday as far as I know. So if you did see him on Thursday then you should have also done the lottery!

    Yes,...

    Tom

    March 12, 2015 at 2:39 pm

    #1783724

  • RE: Today's Random Word!

    Ed Wagner (3/12/2015)

    whereisSQL? (3/12/2015)

    Ed Wagner (3/12/2015)

    crookj (3/12/2015)

    djj (3/12/2015)

    crookj (3/12/2015)

    Revenant (3/12/2015)

    Ed Wagner (3/12/2015)

    djj (3/12/2015)

    Stuart Davies (3/11/2015)

    BWFC (3/11/2015)

    Misdirection

    Sat Nav

    Global

    International

    Intentional

    Premeditated

    Murder

    redrum (reading it again at this time).

    Shining

    Armor

    Sword

    Fish

    Tom

    March 12, 2015 at 2:10 pm

    #1783717

  • RE: Don’t Understand? You’re About to Learn Something

    Andy Warren (3/9/2015)

    Gary, I don't any experience with Eastern culture, but what you say fits my impressions from what I've read about it here and there, I had not considered...

    Tom

    March 9, 2015 at 5:52 pm

    #1782744

Viewing 15 posts - 1,891 through 1,905 (of 7,483 total)