Forum Replies Created

Viewing 15 posts - 9,706 through 9,720 (of 39,903 total)

  • RE: Practical Hekaton

    DanMcClain (6/12/2015)


    I think its great that Microsft does the early (not always perfect) for us early adopters. We have SQL 2014 in production utilizing Column store index, filetables, and In-memory....

  • RE: The Rename Game

    Bill Talada (6/12/2015)


    After reading all posts, I see everyone is doing what is right for their environment. Personally I would only work for a company that strives for clarity...

  • RE: The Rename Game

    tom.w.brannon (6/12/2015)


    I had a situation where in older tables a column was named CNTRY_CODE due to column name length limitations at the time. When the name length restriction went away...

  • RE: The Rename Game

    Dan Guzman-481633 (6/12/2015)


    Yes, I sometimes rename objects and columns. Our development process is Agile with Continuous Integration. Database changes checked into source control are deployed to QA every...

  • RE: The Rename Game

    h.tobisch (6/12/2015)


    i DO renaming.

    To find all references to the old name i use script which simply scrawls through all my sources

    and looks for occurrences of the old name.

    How often?

  • RE: The Rename Game

    Ed Elliott (6/11/2015)


    Hi,

    Renaming is vital when maintaining a database as it means you can refactor it to improve the quality of it. The areas I mean are having consistent naming,...

  • RE: Practical Hekaton

    jwbart06 (6/11/2015)


    Last night at our PASS Chapter user group we had a gentleman that has moved many of his servers to 2014 and he did a great talk on the...

  • RE: Insert without a PK

    just the clustered index

  • RE: Insert without a PK

    Arrrgg, apologies. That's what I get for trying to fix things quickly.

    Question corrected to disable the PK, and not the clustered index.

  • RE: SQL Server Data Lost on User DB's

    Thanks for the final note and good luck with all of this.

  • RE: Practical Hekaton

    Eric M Russell (6/11/2015)


    However, for most SQL Server users, it's confusing when attempting to keep tabs on all the limitations and asterisks surrounding things like: Heckaton's compiled procedures can only...

  • RE: SQL Server Data Lost on User DB's

    Good luck. If you need more help or get more info, post back. We're happy to do what we can.

  • RE: HASHBYTES

    I don't understand the confusion. Hashbytes cannot add a salt. The programmer adds it, which is the answer to the question and what is shown in the link you posted.

  • RE: HASHBYTES

    Junior Galvão - MVP (6/9/2015)


    Hi Steve Jones,

    I appreciate your question, but the answers are a little confusing if we look at the Books Online and other blogs, like this: http://www.mssqltips.com/sqlservertip/3293/add-a-salt-with-the-sql-server-hashbytes-function/

    Regards.

    What's...

Viewing 15 posts - 9,706 through 9,720 (of 39,903 total)