The Lounge is rated PG. If you're about to post something you wouldn't want your
kid sister to read then don't post it. No flame wars, no abusive conduct, no programming
questions and please don't post ads.
An advanced language for querying databases that doesn't involve tons of ridiculously intricate frameworks and mysterious black box middle-tier software. Preferred by people who break out in a rash anytime something becomes more about the architecture then getting stuff done.
Then we have made no progress in 40 years since SQL was developed, if a 40 year old technology is advanced. You must think that there has also been no significant improvement in software languages in since Fortran 1V.
Then we have made no progress in 40 years since
SQL was developed, if a 40 year old technology is advanced. You must think that
there has also been no significant improvement in software languages in since
That of course has nothing to do with what I said.
Unless of course you think that Fortan or something like C++/C+#/Python exist to solve data storage problems.
Solid advice but the ONLY time I ever use the delete command is to clear test database tables. I never use delete in production - everything is a log and if the user doesn't want to see it anymore a flag is set on the record.
I was getting burned too often by people who would blame me for bad data.
Every item and every change is logged and nothing is ever deleted.
Agreed, solid advice, but cloud storage (my company is in Azure now) makes soft deletes expensive. What we've started doing is setting soft deletes on large blobs, then purging those older than 90 days every month or so; if they don't notice it in 90 days, then YAGNI
If get in the habit of putting all your statements inside a transaction, then if you realize you made a mistake you can roll it back without affecting the table.
Of course, you have to remember to commit the transaction in a timely manner, otherwise the table remains locked.
If your actions inspire others to dream more, learn more, do more and become more, you are a leader.-John Q. Adams You must accept one of two basic premises: Either we are alone in the universe, or we are not alone in the universe. And either way, the implications are staggering.-Wernher von Braun Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.-Albert Einstein
I'm not sure, but it may depend on the driver. We use the Jet4 oledb driver for Access and it is quite happy to delete with or without the *. Our apps run can use either SQL Server or Access for the backend, and Delete operations don't require any special handling. (aside from date delimiters) Basically, if it works in Access, it will work in SQL Server, but not always the other way around.
I have been reading about the effect of hurricanes in Cuba. It is unbelievable to think that in this century which is barely a decade old there have been 7 hurricanes with over a billion dollars of damage, the worst being Ike which was 7.3 billion. Considering the impact in the US, this is so much worse. Cuba has a GDP of $57 in 2010. Compared to that the oil rig fire is nothing.
Most of them want to just 'talk-and-bark' on the wire including the confidential and important details but are hesitant to put something in black and white and get it liaised through their SMTP. Is this an indication of their inertia/laziness or some sort of shadowy gesture?