@xsevensinzx

I agree that leadership is important. In the case I wrote about, they each thought that they were individually responsible for particular work items. In a sense they were but...

Yes, Gail is right, if, from the database perspective, the xml or JSON represents an unsplittable data item, then you can legitimately store it as such. Sure, it could be...

@eric

Cor, you're quick. Yes, I think that's a good way of looking at it!

@eric

Thanks Eric,

Some great ones there. I agree that those are all Table smells.

@gary

If exists (select * from myTable) begin ... End

... is surely legitimate since they fixed the optimiser (was it SQL2000?)

You would have thought that all those sites that give the answers to all the common questions would make life more difficult for us as interviewers. I always ask the...

I once interviewed a candidate that was very obviously a different person to the one I did a preliminary telephone interview with. I politely terminated the interview when it became...

Great article, Steve, because it illustrates the way that one has to go about finding a solution. However, because you don't like PatIndex, it all gets a bit complicated. Why...

@robert

I don't think there is a website that does justice to the topic of using SQLite in Windows, though SQLite's own website is excellent for general information on SQLite. I...

@Ed

Yes, I've done plenty of work with both XML and JSON, but I'm no expert in XML. I find that using SQLite is generally much faster for the jobs I...

@paul-2.

You are quite right. I should have checked my facts. He was pronounced guilty of high treason. He initially said that his motives were to 'to blow you Scotch beggars...

I worked for six years with a world-famous motor manufacturer, in their R&D department. Unless a hell of a lot has changed, there is no chance whatsoever that management weren't...

@jeff Moden

It was a difficult booklet to write because I was merely trying to record those things that were considered by people cleverer and more experienced than I to be...

@TomThomson

Is this the SQL Code Smells ebook you're referring to? I wasn't sure, since there were 120 SQL Code Smells itemised, not 27. If it is mine, I'll get the...

If you haven't done so, it would be worth checking whether this will work with all the different language and DATEFORMAT settings. (actually I suspect it will work but that...