Forum Replies Created

Viewing 15 posts - 20,716 through 20,730 (of 39,961 total)

  • RE: Overusing Identities

    It's not a question of the origin of the number, but the fact that it's arbitrary-generated, and as such isn't necessarily a PK. In the paper world, when someone generates...

  • RE: Overusing Identities

    Les Cardwell (3/1/2010)


    Steve,

    I'm shocked! :w00t: The only purist rationalization for a surrogate PK is when no 'natural key' exists. Otherwise, it's just a throwback to mainframe days when files...

  • RE: What are SQL Saturdays?

    There are a few places that do a Code Camp/.NET event with a SQL Saturday. No reason not to do them together if you can find the space.

    Space is certainly...

  • RE: Administrative rights for DBA's

    In the environment where I had separate accounts, it was mainly for security from viruses. We didn't want some trojan or virus to have elevated rights, so the idea was...

  • RE: Are the posted questions getting worse?

    I was listening, but had to stop when it went to overtime to replace a faucet. I was watching the tweets to keep up with what was happening. It was...

  • RE: Overusing Identities

    RalphWilson (3/1/2010)


    ... however, if you add a GUID as your identity column and make it a PK, then you have, essentially, made a random number your PK.

    Good point....

  • RE: Overusing Identities

    Roger L Reid (3/1/2010)


    Steve, I'm a bit surprised at this statement from you, since you're not just another procedural developer lost in a declarative world. You've been writing...

  • RE: Reaching for the Clouds

    Doh! Didn't realize that. My apologies to Boston and the staff the Beth Israel.

  • RE: Multiplatform ODBC support for SQLServer

    No idea. The team working on this asked, so my guess is they are somehow trying to determine if this will sell licenses.

  • RE: SQL agent job running using wrong account.

    I thought that was the case. The last person to edit the job ended up as the owner, and it often used their credentials for things.

    Very, very annoying

  • RE: Timing is Everything

    Scott Arendt (2/26/2010)


    I REALLY HATE time zones.

    I really hate Daylight Saving Time.

    Even if you store job schedules in UTC (which we do), you still need to handle changes related to...

  • RE: Timing is Everything

    philnewell (2/26/2010)


    The decision on using UTC dates should be resolved in the design stage of any system. IF! the application in ONLY ever going to use local datetimes, then...

  • RE: Timing is Everything

    Clive Chinery (2/26/2010)


    I agree that GMT is more understandable than UTC!

    I agree here. It's still GMT to me, but I was worried everyone would correct me to be UTC!

    Now...

  • RE: Stopped getting newsletter

    I don't know, but I'll pass this along.

Viewing 15 posts - 20,716 through 20,730 (of 39,961 total)