Search results

That is not a good query because it isn't SARGable. The criteria should involve operations on the current date that are calculated once, rather than being applied to FieldDate which requires every record to be processed and cannot use the index on FieldDate. The difference in performance won't...

Of course it is valid and efficient in its operation. What I am wondering is why you bother making all this extra work and what you imagine you are gaining over using ODBC linked tables and bound forms. Many developers with a fetish for using SQL commands don't seem to realise that they are...

Yes it is because an atheist business owner cannot consider the applicant's distasteful religious belief as reason not to employ them.

What do you perceive you are actually gaining over simply using linked tables? ODBC passes queries through where it can so it isn't likely to make significant performance differences under most circumstances. You are certainly making a whole lot of extra work. Part of the whole reason for using...

The frenzied postings by Aziz Rasul are doing a great job of turning people away from his brand of faith by portraying Muslims as mindless extremists.

In Australia it is illegal to discriminate on the basis of religion. Except of course for religious enterprises such as faith based schools who are allowed to discriminate against those who don't subscribe to their beliefs. It is hypocrisy of course but that is a fundamental tenet of religion.

The name TempVars is ironic as they are more persistent than any VBA variable, holding their value after a VBA reset. Some people think this is an advantage. I've never used them and never will.

The important matter of whether a query is SARGable or not has absolutely nothing to do with whether a field is going to be updated or not. Your comment ended in a question mark. I was asking what your question was. Did you actually have a question or was it meant as pointless rhetoric?

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...