User not logged in - Sign In - Register
Home Message Center Calendar Photo Gallery Search Hook Up Message Boards Users Help
Check out socialdetour.com for lots of new features.
Gallery » Imperfect Clark
don't break don't break don't break 
Click here to copy the code below.
[img]/UserData/Imperfect Clark/Images/20061220015259.jpg[/img]

Report this photo

Description
No matter how confident you are of what you're doing, any query that modifies FIFTY THOUSAND records on a live server is tense business. Took 9 min and 18 seconds! Though we ran one that took like 4 hours recently.
Comments
timeconsumerx
129 Photos

debug plz

12/20/2006 8:15:55 PM

Imperfect Clark
116 Photos

My speciality is bugging.

12/20/2006 8:25:11 PM

Imperfect Clark
116 Photos

That is table 'SITE' - every one of those rows corresponds to a full-blown Web site we service, manage, or host (though thousands are defunct demos and stuff, meh)

[Edited by Imperfect Clark on 12/20/2006 5:41:46 PM. Reason for edit: fux]

12/20/2006 10:37:27 PM

Imperfect Clark
116 Photos

heh, mysql

12/21/2006 2:38:27 AM

Lysander
1 Photos

gtfo elitist fanboi

12/21/2006 3:40:56 AM

Lysander
1 Photos

nobody even mentioned operating systems or web servers, yet you're proclaiming your fanboish loyalty to appear elitist

i maintain: gtfo

12/21/2006 3:57:09 AM

Lysander
1 Photos

http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems

wow look at all those sql-based database systems

12/21/2006 5:23:33 AM

Imperfect Clark
116 Photos

^^ Obvious OS/platform preference? Pretty assumptive. I was "heh"ing at the notion of managing our system with mysql - fire away, I'm ready. Just bear in mind that, principly, I'm in agreement about the integral superiority of *nix, Apache, etc... (and so is about everyone, last time I checked) And Andrew's definitely right about that elitest vibe from open source pundits. Of COURSE open source is wonderful... boasting about the superiority of open source software is usually just a ploy to make everyone aware of how immersed/knowledgeable you are.

I'm not that in love with the Evil Empire, but this is capitalism... for a small business like ours, an MS partnership is practical. And uh, VS .NET 05 is pretty nice.

[Edited by Imperfect Clark on 12/21/2006 1:38:58 AM. Reason for edit: engrish]

12/21/2006 6:34:05 AM

Imperfect Clark
116 Photos

I'm by no means an amazing programmer. I'm lucky to know a few, though.

12/21/2006 6:38:14 AM

GLintch
119 Photos

^ I second teh GTFO

Most sustems I have seen developed for non-MS platforms don't look shyney or customer freindly at all. At time I redo those systems with great pleasure of keeping the customer in mind. Unfortunately when I had the displeasure of looking at non-MS systems they were often build like cap, in a business sence - which implied disregard for business needs and just plan poor solution skills on the part of the programmers and DBA's who have supposedly built these systems[although I've seen tons of copy&paste from scripts sites]

So imho and some experience small busineses are getting pwned[not in a good way] by non-Msft "platform" solutions.

12/22/2006 1:23:46 PM

AntaresUSF
297 Photos

BEGIN TRAN
-- Your statement goes here. Wait for the results you want
-- COMMIT TRAN -- After verifying your results, highlight this line and execute

12/22/2006 3:24:32 PM

Okrbot23
226 Photos

did I just witness a couple of salvos in the "Programming civil war" cause uh...that shit just went over my head, granted im a gaming nerd and not a comp nerd. regardles, "Power to the people!"

12/22/2006 5:23:40 PM

Lysander
1 Photos

i'm actually on kraft's side, i just hate it when anyone proclaims random, uncalled-for loyalties

mmm, pepsi

pepsi is SHIT.
sprite > mountain dew.
full-throttle > sobe.
barq's > mug.
coca-motherfuckin-cola FOR THE WIN. *headbutts opponent in testicles*

*grasping testicles* dude, why?

12/22/2006 9:14:04 PM

Imperfect Clark
116 Photos

I think people confuse user-friendliness with familiarity, with regard to the user-friendliness of Microsoft apps. Microsoft popularized all kinds of interface styles that weren't necessarily streamlined and perfect, but we all adapted and those methods became centralized as "normal". A simple example would be the sense of dullness that Java apps give off... in terms of interface theory, the differences to C-driven MS GUIs are negligible. However, even the most ornamental things like fonts, colors, and the appearance or depth of buttons/panes/etc can make a difference in how quickly new users close the gaps of evaluation/execution.

12/22/2006 10:58:39 PM

AntaresUSF
297 Photos

^ Agree. I always like to cite the example of how people unfamiliar with macs frequently refer to them as being "difficult to use" and not "user friendly." I even saw many network admins bitch about Windows 2000 when they were used to NT 4.0.

[rant]
And, speaking of which, this looks like Query Analyzer. One of my favorite development tools, with the exception of it's shallow undo buffer. I am highly, highly disappointed in SQL Management Studio. Not only is it a major resource hog that takes a noticable amount of time to launch and a total pig if you're running it locally on your server, but it's also highly unreliable. It locks up for extended periods of time, crashes, is very slow to respond when you're querying bits of database schema (e.g. object browser). If your connection breaks and you try to re-run your query after reconnecting, it automatically sets your active database to "master," so that script you just ran that created 50 tables and 300 sprocs just hosed your server. Microsoft could've probably pretty easily made QA SQL Server 2005 compatible and shipped it to us, but they didn't. You can't view stored procedure source in for 2k5 sprocs in QA.
[/end rant]

12/24/2006 12:01:54 AM

Imperfect Clark
116 Photos

Yeah, it's Query Analyzer.

quote :

after reconnecting, it automatically sets your active database to "master," so that script you just ran that created 50 tables and 300 sprocs just hosed your server



Haha, shit.. I'll keep that in mind next time I run a lengthy script.

12/24/2006 4:18:45 AM

timeconsumerx
129 Photos

perhaps theres a reason why certain OSs are more popular?

perhaps its because only people who dwell upon the minutaie of computer operation prefer a more complicated yet more applicable operating system

while the casual computer user prefers to use something thats been shed of technicalities to more suit their needs?

12/24/2006 5:17:48 AM

shchmue
21 Photos

adopting an OSS solution without an experienced admin is suicide. MS offers, among other things, certifications to try and ensure a large number of people know what they're doing when using their products.

please don't peg me to one side, i just like to be fair. kraft, you're being really biased and not acknowledging the advantages of a standardized set of tools versus ones you build yourself.

12/24/2006 6:44:29 PM

Imperfect Clark
116 Photos

quote :

perhaps theres a reason why certain OSs are more popular?



Most everyone here is running Windows, and I can guarantee that most were using it before they had seen/tried other systems. Microsoft came to prominence through effective business methods, not popularity. I think it will be a long time before we see OS's emerge solely on its merit and popularity. At this point running Linux (or even OS X) is choosing to make all kinds of sacrifices due to the prevalance of prioprietary Microsoft software.

12/24/2006 6:54:07 PM

AntaresUSF
297 Photos

Not to mention, free software isn't really free. They say that 70% of the cost of software is support. I would have to assume that it takes a higher level of skill to maintain Linux systems, thus savings in licensing get eaten up in personnel. Also, corporations usually pay for their software licenses over time -- e.g., that $700 Windows Server license you bought for your $20,000 server is absorbed over five years. SQL Server's licensing makes it quite affordable as well. To compete w/ products like MySQL, SQL Server 2005 (branded as Express) is free if you don't use more than one CPU and your database is smaller than 4 GB.

12/24/2006 8:26:54 PM

GLintch
119 Photos

^ Agreed. Also the whole Microsoft [blank] Express product line from MSFT is exploding the .NET and MS SQL market by inviting more prople to create more with less [and yes less knowledge too, since we are heavily targeting hobbyist and home 'tinkerers' not Dev Pros (who are also using them to smaller projects for smaller cleints) ].

12/24/2006 9:58:43 PM

timeconsumerx
129 Photos

good point, clark.

12/25/2006 12:30:27 AM




This site is not affiliated with the University of South Florida.  USFBullshit.com is not responsible or liable for any information or files posted on this web forum. Please remember you are responsible for the content of your message. Information posted on this site does not represent the views of the University of South Florida. All logos and trademarks in this site are property of USFBullshit.com or their originator and may not be used elsewhere without explicit written permission from .

Copyright© 2001 - 2024 - All Rights Reserved