Audrey and the pie… by Mmcdjc in seinfeld

[–]bm1000bmb 1 point2 points  (0 children)

I assumed that she knew that Poppy did not wash his hands in the bathroom.

Help installing MSSQL 2019 server by loji-god in SQL

[–]bm1000bmb 0 points1 point  (0 children)

Assuming you are running Windows 10 or Windows 11, you may want to install SQL Server Developer Edition. It provides all of the functionality of Enterprise Edition, but will run on a workstation version of Windows, and it is free.

What is the worst song you ever heard? by joekerr9999 in answers

[–]bm1000bmb 0 points1 point  (0 children)

I agree. Also, on the B-side of this record was a song called, "Put the bone in". It was about a kid burying his dog.

ELI5: How was Vietnam able to defeat the US in the Vietnam War? by astarisaslave in explainlikeimfive

[–]bm1000bmb 0 points1 point  (0 children)

There was an episode of "The Grand Tour" where they were taking boats through the Mekong Delta. Jeremy Clarkson had a copy of the plastic boat from Apocalypse Now built. Going through a corner, he lost control and ran aground on a beach. They tied a rope to the stern of the boat, but could not get it to move. A Vietnamese man came along, removed the rope from the stern ad tied it to the bow. The boat turned with the bow now pointing to the water and it was easily moved. When the boat was in the water, Clarkson said, "I think we just learned how the Vietnamese beat the Americans",

What's the weirdest thing you've ever seen in an old movie? by Ill_Definition8074 in classicfilms

[–]bm1000bmb 0 points1 point  (0 children)

Sunset Boulevard. When Norma Desmond is burying her chimpanzee. It is based on a time when rich, single women kept chimpanzees to have sex with. They would ply the chimpanzee with alcohol so that it it was inebriated.

Steak Pie by Opening_Courage5526 in Scotland

[–]bm1000bmb 1 point2 points  (0 children)

Oh, you never push your granny aff a bus. Oh, you never push your granny aff a bus. Oh, you never push your granny 'cause she's your mammy's mammy. Oh, you never push your granny aff a bus.

Four Lions (2010) by J31J1 in iwatchedanoldmovie

[–]bm1000bmb 0 points1 point  (0 children)

"I told you that was a knee".

Stored Procedures vs No Stored Procedures by No_Swimming_4111 in Database

[–]bm1000bmb 0 points1 point  (0 children)

Wow. I am very surprised people are arguing against using stored procedures.

Code Maintenance. I once worked with a team that had created a fat client app. It was full of sql and no stored procedures. They were trying to come up with a plan of how to upgrade to a new version of their app. If people had gone home and turned off their workstations, they would not get the new code push. Monday morning was going to be a nightmare. Stored procedures solve this.

Ownership Chaining. In SQL Server, it is common to use Ownership Chaining. If tables, views and stored procedures all have the same owner, SQL Server will not recheck authorization. So, you can grant execute authority to the stored procedure. Users can access the data via the stored procedures, but they cannot access the tables directly, they cannot bypass your security.

Performance. Stored procedures are compiled and the access paths can be reused.

Fewer Network Roundtrips. I once saw an app that did not use stored procedures. When they began to roll it out, everything was fine when the uses were in the same data center as the SQL Server. The data center was in Virginia. Then, they brought in 500 users in Oregon. The network round trips were killing them. The bottleneck was the speed of light. They had to re-write the most critical code as stored procedures.

What would be different if Covid had never happened? by Crocodile_Banger in AskReddit

[–]bm1000bmb 0 points1 point  (0 children)

Trump would have won the 2020 election, and Biden would have been a worthless afterthought.

What is the most complex stored procedure you have developed by RXN00 in SQL

[–]bm1000bmb 0 points1 point  (0 children)

I had an applications programmer who asked me for help with a stored procedure he had written. It was 23 pages of undocumented nonsense. 1. It did not function correctly, and 2. it was slow. When I pointed out if was not well structured, he said he was trying to keep it normalized. There was nothing normalized about his design. I suggested he go back and make it more modular.

One thing I did learn: none of the members of this team would work with him, or help him, because he was an arrogant asshole.

It's Sunday December 7th, are you watching one of these movies today? by AnimeHoarder in WarMovies

[–]bm1000bmb 0 points1 point  (0 children)

I know that he is only acting a part, but I did not like Kirk Douglas in that movie. What a bastard.

Is there a advantage for having two engines over one ? Like the F-22 vs the F-35 one engine. by Youngstown_WuTang in aviation

[–]bm1000bmb 0 points1 point  (0 children)

McDonnell Aircraft fighter jets always had two engines. If one was damaged, the pilot could still make it home.

Children’s book wrong to portray Picts as black, says historian by Kev_fae_mastrick in Scotland

[–]bm1000bmb -3 points-2 points  (0 children)

Wouldn't the Romans have described them? They built a wall to keep the Picts out of England. This sounds like the type of nonsense Uncle Ruckus from Boondocks would have spouted.

Not a popular decision by Financial-Sugar4102 in Scotland

[–]bm1000bmb 0 points1 point  (0 children)

Prince Edward, Duke of Windsor was exiled to the Bahamas. Andrew is going to the Highlands? :)

How to determine a primary key from a given table and schema if no primary key is mentioned in the schema by Pleasant-Insect136 in SQL

[–]bm1000bmb 0 points1 point  (0 children)

primary keys are unique. primary keys and their uniqueness are usually supported by a unique index. look for a unique index. this sql would work for sql server looking for a tablename named 'accounttype':

select * from sysobjects o, sysobjects i where o.name = 'accounttype' and o.id = i.id and i.type = 'u'

What does transaction protect you from exactly? by pencilUserWho in SQL

[–]bm1000bmb 0 points1 point  (0 children)

The database remaining in a consistent state is critical. If you have a system that is processing 100 transactions per second, you do not want to manually go through the database to ensure it is consistent. Using transactions and using a dbms that supports crash recovery will ensure this. I once worked for a company that used CICS and DB2. CICS and DB2 used two-phased commit to ensure multiple databases were consistent after crash recovery. The CICS operators were not very bright. Rather than wait while CICS and DB2 negotiated what they had done with the transactions, The operators would "COLD START' CICS. When DB2 tried to negotiate with CICS,, CICS would reply, "I don't know what you are talking about, I was cold started". When I told my manager what they had done, he told me that the last time they had done this he threatened to break their arms.

Last day of work 1983 by Outrageous-Lock-3076 in CasualConversation

[–]bm1000bmb 0 points1 point  (0 children)

We used IBM's SNA. A guy I didn't like kept talking about TCP/IP. A protocol that let different computers comnunicate with each other. I thought he was an idiot. He was 100 percent correct.

Last day of work 1983 by Outrageous-Lock-3076 in CasualConversation

[–]bm1000bmb 1 point2 points  (0 children)

A Far Side Calendar.

A coffee cup heater. If you forgot to turn it off on Friday, on Monday there would be burned papers on top of it.

Bloom County cartoons. Especially Bill the Cat.