Good article.

I've done a relatively extreme version of "all the rules and logic in the database", and a middle-of-the-road version, where some of the logic and rules are in the...

Good article. Most devs (database or otherwise) don't understand enough about the query optimizer and how it works with indexes, and your article has a good example of that.

The part in the error message about a timeout makes me wonder if it's a network issue as opposed to an authentication issue.

Have you tried sending e-mail through that same...

Don't apply any that you don't actually need. That's what Microsoft recommends, and I tend to agree with them on that point.

Good article, good discussion.

I always try to have as much patience as possible with questions on these forums. I have to agree with Jeff that obvious interview/test questions have...

Arithmetic overflow means you have a numeric value larger than 6 digits (since you're casting as Numeric(6)). The "E" isn't causing the problem in that one.

You can use the...

The problem isn't that it's the same value in both columns, it's that you're trying to add the same row more than once.

Either add a Where clause that makes it...

You need to change this:

SELECT COUNT(*) AS [@AllMarketsCount]

FROM .......

WHERE ........

SELECT COUNT(*) AS [@UploadedMarketsCount]

FROM .....

WHERE ......

To this:

select...

Here's what I suggest: Create a ProofOfConcept database on one of your dev boxes (or your only dev box if you just have one, I guess 🙂 ). Create...

It would be very helpful if you posted the code of the query, as well as the execution plan. Can't really do much with just the execution plan.

In general, you could run a trace on the server, and find out what, if anything, is running at the same time or right before it.

For anything more specific, I'd...

Varchar can hold accented/marked Roman characters (like French, Spanish, German, etc.). What you need nvarchar for is Chinese characters, Arabic characters, Greek, etc.

I would create a trace on the database, see what's connecting to it (if anything) and track that for a while. If no activity except you checking in on...

Gotta agree with just about everyone here. Treat the physical disks in the SAN the same as you would internal disks, when it comes to SQL performance and disaster...

I'm not clear on what you mean by parent and child constraints, unless you mean Primary Keys and Foreign Keys.

If that's the case, script the tables, including their keys, then...