Search results

Your proselytising is becoming tedious.

I strongly suspect the whole problem is due to inappropriate table structure and your source data should be stored in a table something like the output of June's first query.

You are talking about the empirical evidence for Einstein's theoretical work. These researchers are claiming that the magnetic levitation (albeit incomplete) is empirical evidence.

Is it the front end or back end that is runing out of resources? What version of SQL Server are you using? Express or Standard?

That doesn't sound right. You should be able to pass numeric arguments. I've not included parameters in a console app before but I expect they would be individually declared on Main().

Living in the US isn't something worth aspiring to.

He achieved a lot of horrible things. Of course I agree that the best outcome would have been had he never existed but his death at the earliest possible time would have been the next best outcome.

I wasn't comparing Kevin to them. I was responding to you strange claim. Sounds like a mindless religious belief held in denial of reality.

Hitler was responsible for the death of millions upon millions of people. The only sad thing about his death was that it didn't happen a lot sooner. You insistence that his death was a tragedy says a lot about you. Where did you kill these people? It has obviously affected you in a very big way.

So Adolph Hitler's death was a loss? Vladimir Putin? How about serial murderers, rapists and pedophiles? I celebrated when my paternal grandfather died. The world became a better place without him. There are a lot of people we would be better off without.

Wow. He became a security consultant after he died?

American don't seem to realise how weird their religious behaviours appear to people who live in countries where rationality is valued. So glad I am not condemned to live in the USA.

Procrastination is a strategy to overcome Parkinson's Law. Use the procrastination time before starting to visualise complex system as a network of simple systems obeying thus Gall's Law. Address the Pareto Principle by identifying early which twenty percent of parts are going to be the problem...

How much experience do you have building web pages? Building one to work with a database as your first would be like trying to ascend a vertical cliff as your first climb. It is also easy to build a page that will make your database vulnerable to attacks if you don't know what you are doing.

Keep a fresh front end in a central location and copy it to the users' sessions every time they open the application. This can be done with a batch file.

Are you creating tables or adding and removing temporary records from tables in the the front end? If so that will cause bloat. If so, move any of this activity into a separate temporary database that is created on demand.

Causing a form to pop up when hovering over a control is possible but seems an extreme response with a lot of overhead to run. I couldn't recommend it. Why not do it on a click of double click on the control?

You don't. DateTime fields are for recording moments in time, not amounts of time. Record the number of seconds, minutes or hours is integers and sum them.

(Half joking) Maybe Surname is a weird word. I have a query in SSMS where SURNAME is a column in a Temporary table. No matter what I do, SSMS is absolutely convinced it is an invalid column name when I refer to it in the main main query. It is perfectly happy with all the other columns in the...

I have had cases where I could see the reality would be that the program settings would need change in the future, despite users assuring me that it wouldn't. So built in what made sense and simply hid the extra functionality from the front end. Sure enough, before long, the request to change...