Forum Replies Created

Viewing 15 posts - 91 through 105 (of 160 total)

  • RE: Getting Fired

    How about getting fired for spending too much time reading the editorials and comments on SQLServerCentral?

    Hopefully not true, but someone did mention Facebook.

  • RE: The Worst Code

    Well maybe close to the worst code I have ever seen was written by me. We had 16k of room to print out a large document in an old...

  • RE: Downtime

    We do the Chaos Monkey in software development all the time. I am kind of surprised no one has recognized this. Testers are supposed to find ways to...

  • RE: Big Data Comes to Hiring

    I thought the article (from the Atlantic) was both interesting and somewhat concerning. Companies like Gild are attempting to quantify how good a developer is based on social media....

  • RE: Adding to SQL Server

    When setting up a job activate Ctrl-A for select all LIKE EVERY OTHER WINDOWS PROGRAM IN THE UNIVERSE (in the SQL Job Command Window). Plus I love the CREATE...

  • RE: Common Checks

    phegedusich (1/24/2014)

    --------------------------------------------------------------------------------

    "While we considered changing to a bigint, this was a third party product and they did not want to allow us to alter the schema."

    There's your problem. Perhaps testing...

  • RE: Picking Your Packaging

    The first consideration is your company not you. That said if it's a one off project then I'd say there is some latitude otherwise it I would think maintainability...

  • RE: Sabbatical

    You've mentioned in the past that you run at least some for fitness. You could go for 6 weeks of fitness crazy. It's now well established that exercise...

  • RE: Looking to 2014

    One area of movement will be the accelerated movement to SSDs. They are dropping in cost rapidly and I think we'll start seeing them in more and more systems...

  • RE: SQLServerCentral apologizes and you can win a book

    I wrote this so I could learn how to use it. It was to get the number of labels by item and the particular # you were one: ...

  • RE: Visitor Parking

    SELECT "Hulk Smashed" FROM Parking_Lot WHERE Type = 'Visitor' AND ElapsedTime > 120.00 AND ValueofCarOwner <= Low

  • RE: Maintaining the Value of My Primary Key Question

    I think Scott's suggestion is the best. It's similar in concept to what we do in our accounting software. Another option would be some sort of hashing routine...

  • RE: Insert Trigger and @@rowcount problem - Performance Issue

    Well I'm not 100% sure but I think we've found the problem. The system we use is interconnected with several other systems some of which are a bit old....

  • RE: Insert Trigger and @@rowcount problem - Performance Issue

    Gail,

    I can't do that (change the code). That could materially change how the trigger works. While in this case it is a single insert (via a values ()),...

  • RE: Insert Trigger and @@rowcount problem - Performance Issue

    But any idea why @@rowcount would be so slow? The line of code doing the insert is a single row insert. I can't understand why it would be...

Viewing 15 posts - 91 through 105 (of 160 total)