Search results

So?

NO! That suggestion is absolutely wrong. This expression requires a function to be run on every record before matches can be returned. Hence it cannot use the index on the date field.The difference in performance won't be noticed on small numbers of records but will become evident as the number...

Import the whole csv into a table as a single value. Then apply STRING_SPLIT with the ordinal argument set. (You will need SQL Server 2022 or Azure.) Then split the multiple records on the commas.

I think that is a fairly common situation. Many database administrators subscribe to hating Access. Some because they have seen troubled caused by Access dabblers who haven't got a clue what they are doing but many just to be part of that culture,

I am fortunate to have always been part of that IT team in my workplace with full access to the network configuration and database administration. Eventually I settled into the role of the designated database administrator as we took on more IT staff. The size of the business I'm in is now very...

I have long argued that putting temp tables in the front end is the equivalent of writing a shopping list in margins of an encyclopedia. Temp tables belong in a separate database which I call a "Side End". There are multiple ways to implement a side end. The easiest is to keep a pristine file...

Are you sure the first query is not still running when you try to open the second query? Although results appear quickly, this does not mean the query has completed returning all the results.

SQL Server can read Excel and Access files.

Aziz is a great example of the mental illness that is religion.

The festival of the solstice predates the attempts by Christians to usurp it for their own morbid story about an angry god who demands the death of innocents to atone for sins. The decorated tree and giving gifts are part of that tradition.

Miracles are things that are beyond the possibility of the physical laws. Bringing dead people back to life (no I don't mean ordinary resuscitation) or healing the severely crippled by waving one's hand at them. Like the Biblical miracles that stopped happening nearly 2000 years ago...

The study moke123 and I referred to is a followup that reveals that strong parental relationships is actually the relevant factor in good mental health and holds independently of the amount of screen time. The fact that conservative parents are more likely to limit screen time and less screen...

I like the sound of that one.

Just as I suggested. The article contorts the original poll to suit the agenda of the publisher. They decided for themselves that a strong parental relationship meant conservative parents. Of course Isaac laps it up because it fits his prejudices. Most of the survey is comparing mental health...

The rise and fall of civilisations throughout history has largely been a process of creating extra wealth which allowed the stupid people to breed up until it collapses. This cycle goes back long before the industrial revolution. However Isaac's notion of the religious being the superior people...

Hardly surprising. The Institute of Family Studies is a religious organisation with an agenda. Their measurement of mental health will no doubt be heavily biased towards their own values.

You clearly have not learnt about databases and refuse to do so. I would recommend you go back to working with spreadsheets. They are more suited to you way of thinking.

You should take notice of what June said. It is a design mistake to have six tables, and you will be using clumsy workarounds forever if you continue down your current path.

The New Testament was not contemporary with the supposed existence of Jesus and its authors are unknown. There is zero evidence that it is any more than a complete work of fiction designed to claim that the prophecies of the Old Testament had been fulfilled. There are no verifiable accounts of...

Rational conclusions cannot be reached though comparisons of mythology. None of this is recorded in history. There are no contemporary accounts of Jesus from the time when he was supposed to be a person of note, let alone accounts of what supposedly happened to an obscure couple in barn in...