Forum Replies Created

Viewing 15 posts - 10,141 through 10,155 (of 26,489 total)

  • RE: Are the posted questions getting worse?

    Jeff Moden (8/13/2012)

    To be honest, I normally use surrogate keys and, if the data needs it, I'll also use "alternate" keys which are usually some form of natural key. ...

    August 13, 2012 at 12:44 pm

    #1525226

  • RE: SELECT statement

    Here is another possible solution. The key here is simple, test, test, and test again to find the correct solution to you problem.

    CREATE TABLE dbo.testtab(

    ID...

    August 13, 2012 at 12:06 pm

    #1525210

  • RE: comma in SQL

    OTF (8/13/2012)

    Lynn Pettis (8/11/2012)

    CELKO (8/11/2012)

    CELKO talked aobut DDL of my post, but here I only ask the question about the extra comma

    A reflex on my part. I assume...

    August 13, 2012 at 11:02 am

    #1525183

  • RE: Easy way to use timestamp for updating warehouse

    Just to be sure what we are talking about. The timestamp is an actual date/time value, correct?

    August 13, 2012 at 10:44 am

    #1525176

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (8/13/2012)

    Matt Miller (#4) (8/13/2012)

    Jeff Moden (8/11/2012)

    L' Eomot Inversé (8/11/2012)

    I wouldn't claim that the problem can be avoided, simply that it is just as serious with (application-visible) surrogate...

    August 13, 2012 at 10:42 am

    #1525170

  • RE: One restore or many, many restores

    I have to agree as well, taking a full backup of the database prior to an upgrade is the best answer. Remember: backups are worthless (no matter how quick),...

    August 13, 2012 at 9:57 am

    #1525142

  • RE: SQL Tool that integrates into Notepad++

    thomas.oftring (8/13/2012)

    Hello,

    I think you mean the following tool:

    Hope this helps.

    Cu

    Thomas

    Make it easier for others:

    http://www.softtree.com/sqlassist/index.shtml

    August 13, 2012 at 9:45 am

    #1525136

  • RE: Are the posted questions getting worse?

    I overstep the line of professionalism, apologize and say it won't happen again and Mr. Celko gets "offended" (may not be the right word, but all I can think...

    August 12, 2012 at 9:40 am

    #1524851

  • RE: unique constraint

    CELKO (8/11/2012)

    I apologized, I would appreciate it if you would just leave it at that.

    But I do not want you to quit sniping at me. I like adversarial...

    August 11, 2012 at 6:36 pm

    #1524804

  • RE: comma in SQL

    CELKO (8/11/2012)

    CELKO talked aobut DDL of my post, but here I only ask the question about the extra comma

    A reflex on my part. I assume that people want...

    August 11, 2012 at 6:35 pm

    #1524803

  • RE: unique constraint

    CELKO (8/11/2012)

    ...

    Yes, Mr. Celko, you are the all knowing, always right individual and we should all bow to your wisdom and knowledge and kiss your ring.

    Don't forget to buy...

    August 11, 2012 at 3:37 pm

    #1524800

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (8/10/2012)

    Lynn Pettis (8/10/2012)

    Natural keys vs Surrogate keys is one example. I have worked with a database that was designed wrong. But I had to work...

    August 11, 2012 at 1:42 pm

    #1524797

  • RE: Fantasy football 2012

    roryp 96873 (8/10/2012)

    Montana.

    My daughter is visiting a friend up in Bozeman.

    August 10, 2012 at 6:03 pm

    #1524720

  • RE: Are the posted questions getting worse?

    SQLRNNR (8/10/2012)

    Lynn Pettis (8/10/2012)

    Oh, wait, I can't afford a life yet. I have daughter going off college this month and another going in 4 years. No maney money...

    August 10, 2012 at 4:47 pm

    #1524712

  • RE: Are the posted questions getting worse?

    Oh, wait, I can't afford a life yet. I have daughter going off college this month and another going in 4 years. No money for a life. :w00t:

    August 10, 2012 at 4:41 pm

    #1524709

Viewing 15 posts - 10,141 through 10,155 (of 26,489 total)