You only need to test up to the square root of a number to test for primality, which is quite a saving:

declare @n   ...

It strikes me that if someone is having meetings about meetings as mentioned in the article, the problem isn't the tools, but the lack of proper communication and planning. We...

As far as I'm concerned, SQL History works much the same way Tab history used to except that it's much more flexible and easy to use. I really don't see...

There's a good explanation of SQL injection (and how to prevent it) here.

https://www.sqlinthewild.co.za/index.php/2009/04/03/dynamic-sql-and-sql-injection/#more-230

I don't rent music. I like having the physical medium along with the cover artwork and lyrics (if provided).

Just last week I added 6 hour "meetings" to my calendar on 2 days a week just to preserve some time to do "proper" work. I can still accept invitations...

I always assumed we were supposed to answer them without pasting the code into SSMS. Otherwise you're just...

Our C# developers (who know just enough SQL to be dangerous) write code using Entity Framework and I have trust that Microsoft will generate good SQL. So far so...

I wrote an application years ago that loaded data from spreadsheets, stored it in a database, mashed it around a bit and then produced reports. It took around 5 minutes...

Why bother? Because 2 years after implementing the system, the data volume had increased to the point where the overnight batch ran well into the following morning (who'd have thought...

• This reply was modified 2 years, 4 months ago by  Chris Wooding.

On a slightly separate point; I sincerely hope the appointment data you provided is invented data for a dev/test database rather than production as it looks as if it contains...

In case anyone else comes across this as the solution to a similar problem, I had to add ral.id to the partition in order to get it to work with...

Thanks. That works perfectly.

So I would have an Ingredient table (IngredientKey, IngredientSK, IngredientName, Category, UnitPrice, ActiveDate) and then use FILTER() and/or TOPN() to get the most recent active Ingredient value relative to...

I think your Ingredient table containing the price should be set up as a slowly changing dimension (even if it changes fast). That way the Recipe fact doesn't have to...