Post reply

Curiosity Question - Do you run only perfect, never fails software apps on your systems?

  • June 10, 2011 at 11:35 am

    #142732

    I always believed that there was no such thing as %100 perfect/Bug-free software, at least not anything current due to the complexities involved at every level to get something to work.

    There are more realiable applications that seldom have problems (I for one seldom have probelms wiuth Excel) but in general every application will run into some kind of problem at some point since the developer can never anticipate every possible scenario.

    So is it just me? Do you have 'perfect only - never fail' applications using one or more DB on your SQL Server(s)?

    Or would most agree that there is no so scuh thing as 'guaranteed to never fail' modern day software applications that work with DB in SQL Server?

    Kindest Regards,

    Just say No to Facebook!

  • June 10, 2011 at 11:43 am

    #1337164

    I believe 'guaranteed to never fail' software applications do not exist and never will.

    I would also say that most software applications fall very, very far from that ideal.

  • June 10, 2011 at 11:43 am

    #1337165

    lol this made me think and change my signature!

    I was going to do the expected response like "Well every app [font="#FF0000"]I[/font] create is perfect", but i couldn't keep a straight face while typing that.....

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • June 10, 2011 at 12:11 pm

    #1337180

    I have actually written a couple of utility apps in the past that I would consider as close to bug free as you can get but that is largely becuase there use was som one dementional that it was very easy to test. either 2 +2 = 4 or is does not. not alot to test there and not alot of room for error. however software is rarely this simple and the scope of system impact is also much larger than ever before. Even with the best QA team in the world you coul dnot test ever scenrio possible in most cases.

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • June 10, 2011 at 12:13 pm

    #1337182

    I'm involved in a somewhat frustrating case of "to reboot or not reboot" regarding some servers with our IT admins. I know the whole argument for why SQL Server never needs to reboot but in my real world experience we end up having less problems with applications we use when we have some regularly scheduled reboots even if its only once a month.

    I made this post after stumbling across several "You should never reboot if you know what you're doing" replies on other forums site, mostly from IT/Sys admins who deal not with applications but server OS's and hardware and so there world is less volatile then the one dealing with a variety of end user applications, all of which are full of quirks.

    Kindest Regards,

    Just say No to Facebook!

  • June 10, 2011 at 12:23 pm

    #1337189

    IT is 75% oppinoin and 25% fact. The reboot/Boot debate has been going on for more reasons than anyone can remember. Though the points behind the debates have changed we are no closer to getting an actual answer. I recall a rather lively debate when the top of the line system was a 486 processor. The debate at the time was weather shuting down you PC at night was promoting "ship creep" (A process in which the reheating and cooling of the chip would cause the chip to slowly creep out of the socket) The bottom line is do what works and makes sense for you. there are often many different right answers to the question and we will all swear on all we hold dear that ours is the only right one.

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • June 10, 2011 at 12:49 pm

    #1337204

    I know that we had lots of apps with issues, but I have to say, most of our servers were up at least 3-4 months at a time. They'd probably be up longer but SPs and CUs frequently require reboots. I remember back in the 6.5 days when we scheduled a weekly reboot because that's how you kept it from rebooting weekly anyway, just randomly. But since 2000, no, we don't reboot on a scheduled basis, at all on any of the servers, even the ones with really bad apps.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply