Forum Replies Created

Viewing 15 posts - 3,631 through 3,645 (of 39,898 total)

  • Reply To: SQL SEREVR QUERY

    Also, please show the results you expect, or some of them. Format this as plan code, using the code sample button in the toolbar.

  • Reply To: Synonyms for Tables

    I assume this is because you might be doing some refactoring, and perhaps want to point a routine to the specific place while you're using a temp table in place...

  • Reply To: Website search

    crowdsourcing is on the list. We allow tags (now) in the forums, which helps. Content needs more tags, though we had issues allowing random tags on the old site. Need...

  • Reply To: Website search

    Hmmm, keyword searches are definitely hard, and I wish we had something more layered. There are tags for sure that can help, but organizing to get all of xxx is...

  • Reply To: Website search

    We do have a site search, which does limit to this domain for google. You can also limit by content type.

    Is there something you were looking for?

  • Reply To: The First Rule

    That's a great quote

  • Reply To: The First Rule

    The main point of the article is that we should expect data to change and allow for this. Not just with database design, but with the ETL, NULL/defaults, and more....

  • Reply To: Are the posted questions getting worse?

    Ray K wrote:

    Congrats, Steve!  How'd you like Potsdam?

    I have a lot of friends who went to Potsdam.

    Just as long as she doesn't root for Clarkson hockey...! 😀

    It's a neat town. We...

  • Reply To: The First Rule

    dbishop wrote:

    As I see it, there is nothing wrong with "immutable" natural keys. LastName + FirstName + MiddleName as a natural key? NEVER!!!!!

    The one thing I'll say in defense of...

  • Reply To: The First Rule

    RonKyle wrote:

    This is one reason I dislike many natural keys as PKs.

    I don't understand how this follows from the discussion..  First, there's not a whole lot of cases where there...

  • Reply To: Data Migration

    If you are doing updates, then SSIS works great. If this is a full migration each time, there is the SQL Server Migration Assistant that works well. A number of...

  • Reply To: IT Staffer Fired

    A lesson from The Phoenix Project. No one should be above others. You might know more, but you don't get to break rules.

  • Reply To: disable CEIP

    I'd disable the user rather than delete.

  • Reply To: Reading Part of a Dataframe

    Glad you enjoyed it. I missed it when retrying it today as well.

  • Reply To: Using Backup Encryption with an External Certificate

    You alter the key to use the new server certificate.

Viewing 15 posts - 3,631 through 3,645 (of 39,898 total)