Forum Replies Created

Viewing 15 posts - 391 through 405 (of 1,187 total)

  • RE: Surfing

    Great comparison - thanks for the thought-provoking editorial!

    - webrunner

  • RE: Mission Critical Deployments

    I'm a little late to this discussion, but having read "The Checklist Manifesto" by Atul Gawande, I think a whole set of software checklists needs to be run the same...

  • RE: Making Guesses

    Randy Worrell (8/11/2015)


    I agree on the concept of making "guess-timates" when asked to provide estimated time and scope. Almost without fail, any estimate--made in good faith--will be received as having...

  • RE: Print a nvarchar variable

    Interesting question - but I am hoping there will be a final resolution in the comments about a possible error in the explanation?

    Thanks.

    - webrunner

  • RE: Float to Varchar

    Great question - and even more counter-intuitive than the answers usually are!

    Thanks.

    - webrunner

  • RE: Best design for OLTP tables

    Interesting question, thanks. I'm not sure of the best overall solutions for these problems, but it has reminded me I need to think about them more.

    - webrunner

  • RE: Best design for OLTP tables

    Great comment!!!!

    Thanks,

    webrunner

    Uwe Ricken (8/6/2015)


    Luis Cazares (8/6/2015)If identity is ever increasing, how can it create the same fragmentation of a random value?[/Quote]

    Hi,

    fragmentation on an identity value can surely occur if you...

  • RE: Error: 5171, Severity: 16 CREATE DATABASE for tempdb on SQL startup

    GilaMonster (8/10/2015)


    You need to either create that path so that the file can be created, or start SQL in single user mode (remote in to the server and work directly)...

  • RE: Error: 5171, Severity: 16 CREATE DATABASE for tempdb on SQL startup

    OK, looks like I dug myself out of my own hole. A rare but welcome occurrence.

    Here is why I had trouble fixing this:

    1. I had not turned on the DAC...

  • RE: Global temporary table visibility

    Thanks, good question.

    - webrunner

  • RE: NOT IN

    Thanks for the very helpful question. I got it wrong but learned a huge lesson today. NULL is some tricky ish.

    - webrunner

  • RE: List Job Dependencies

    Thanks for offering this script. Just as a constructive suggestion, though, I am curious why someone rated it only 2 of 5 stars. In such cases, I wish the person...

  • RE: SQL login name practices - development vs production

    Jeff Moden (8/3/2015)


    webrunner (8/2/2015)


    Jeff Moden (8/2/2015)


    webrunner (8/1/2015)


    I know the general best practice for SQL Server is to use Windows logins, but we're not there yet.

    I know you already know...

  • RE: SQL login name practices - development vs production

    RTaylor2208 (8/3/2015)


    In the environments I have worked in the SQL logins used by applications have always had the same name \ permissions in each environment the only differentiation being the...

  • RE: SQL login name practices - development vs production

    Jeff Moden (8/2/2015)


    webrunner (8/1/2015)


    I know the general best practice for SQL Server is to use Windows logins, but we're not there yet.

    I know you already know this but I...

Viewing 15 posts - 391 through 405 (of 1,187 total)