Good point. That would cause problems with check constraints, defaults, etc too....

So the lesson is stick with an ISO format! Well, I always have anyway.

Not a clue... but now I'll go find out! Thanks 😀

HAH! Quite true I suppose. Not a problem you're likely ever to run into though, unless for some reason you decide to develop in a different language for the lulz....

That's a good idea and one I had only vaguely considered. I'm not sure how I would approach them though. Guess I'll give them a call 🙂

SQL Server will recognize a lot of date formatted strings. If you declare a date variable you can simply assign to it from one of those correctly formatted string formats....

Nope all code was written at home during (forced) annual leave. I'm aware that companies are generally (string of ugly words here), so I've covered my bases there. 😉

Thanks for your feedback. Yep, this is exactly the kind of stuff I'm thinking about.

We are actually using the addin at my place of work with great success. I'm the...

I would store the ingredients as rows in a separate table, keep the recipe name and instructions in the recipe table. This makes the data model more flexible. As you...

Cool, I'll point them to your post when they complain 😛

It could be a storage related issue, but there are no errors either in the eventlogs or in the checkdb output. I want restarting the sql service to recreate temdb...

One thing I forgot to mention: the database the view selects from is in snapshot isolation mode.

To reopen this topic briefly, I'm not clear on whether a rebuild is not allowed with a varchar(max) if sp_tableoption has been used to force the data to be stored...

Again, yeah, but that's not really the point of the example.

I'd actually argue that it is guaranteed to be unique, depending on how you define "guaranteed". Is it possible...

Yep, that's true. I'm just using this as a contrived example.

(IE, that's why it's not *guaranteed* to be an ever increasing key)

Yup, I chose to use date (I should have said datetime) as an example specifically for contrivane... ie, one user can't put entries in at the same time, but two...