Forum Replies Created

Viewing 15 posts - 316 through 330 (of 14,953 total)

  • RE: FKs with indexes...

    It depends.

    There are always cases where "the rules" need to be broken.

    In a case like that, with 30+ FKs needed, that gets into the realms of both (a) you probably...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Has SQL Query Termination (;) become mandatory in SQL Server 2012?

    Phil Parkin (12/18/2012)


    I saw an example only today of over-zealous use of the semi-colon terminator, with something like this:

    Begin try;

    --do stuff

    End try

    Begin Catch

    --error handling stuff here

    End Catch;

    This does not generate...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    SQLRNNR (12/18/2012)


    Stefan Krzywicki (12/18/2012)


    Brandie Tarvin (12/18/2012)


    Has anyone else noticed that winter starts on the very same day that the world ends?

    How does that work, wonders the author...

    Happy Holidays for those...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Holidays and other Social Technologies

    Bill Nicolich (12/18/2012)


    GSquared (12/18/2012)


    Carse's concept of looking at life as a game isn't anything new. It's been a key part of Scientology.

    Thanks for the book citation. I'll have to...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    GilaMonster (12/18/2012)


    GSquared (12/18/2012)


    Amusingly enough, Mayans vs Vikings is part of one of the dungeons in The Secret World. Apparently the Vikings brought Excalibur to North America and used it...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: How do I add an image to my post?

    Upload the picture using the Edit Attachments button below the editing window. Then use the link for that.

    (If you Quote my post, you'll see how I formatted the link....

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (12/18/2012)


    Brandie Tarvin (12/18/2012)


    Has anyone else noticed that winter starts on the very same day that the world ends?

    How does that work, wonders the author...

    Happy Holidays for those currently...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: HOW TO TABLE DATA VALUE CHANGES MANUALLY DONE BY A PERSON

    safzalhussain (12/18/2012)


    need assistance, how to track changes in sql server 2005 express edition using triggers

    ApexSQL sells a product that will do the work for you on that. Easier than...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (12/18/2012)


    Has anyone else noticed that winter starts on the very same day that the world ends?

    How does that work, wonders the author...

    Happy Holidays for those currently celebrating, for...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Missing Indexes on Temp tables

    ganeshmuthuvelu (12/18/2012)


    I am the OP here. It appears that the thread became a discsussion for whether indexes are needed on temp tables or not. I can say for sure that...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Hi frn

    If you want to force the order by using the ID column, then force the ID column to have the values you want:

    CREATE TABLE #varchar_field1

    (ID INT...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Finding combinations of values

    Eugene Elutin (12/18/2012)


    To SELKO:

    GSquared (12/18/2012)


    ...

    So your point doesn't actually prove your point, if you get my point. 😀

    On the other hand, code portability has certainly worked out well for you....

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    With Audra and the Antidote's "We Wish You A ..." (http://www.lyricstime.com/audra-and-the-antidote-we-wish-you-a-lyrics.html) going through my head, here's wishing everyone here a merry Christmas and happy new year.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Holidays and other Social Technologies

    Carse's concept of looking at life as a game isn't anything new. It's been a key part of Scientology, for example, since the early 1950s. There's actually nothing...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: HOW TO TABLE DATA VALUE CHANGES MANUALLY DONE BY A PERSON

    For the future, you can use CDC (Change Data Capture) to get that kind of thing.

    In order to track down past changes, you'll need to check the transaction log. ...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 15 posts - 316 through 330 (of 14,953 total)