Generally depends on how you did the backups, and why you're restoring.

That looks fine. The Common Files (X86) part is just for anything 32-bit that SQL needs. It's usual when installing on 64-bit boxes.

You don't need BOL and client...

If you're talking about...

If you search for those things in Google, it appears to cap at 32 on Enterprise, and 4 on Standard.

You can't place a check constraint directly on a UDT. (That's actually come up twice this afternoon on this site.)

You can create a table of valid values and use...

Good point, Timothy.

In that case, you're almost going to have to handle it row-by-row. You might be able to build an algorithm for splitting it that would work on the whole...

I made it up as a conversation-starter for interview situations. Hand someone a laptop with this on it, ask them what they would do. Make it clear that...

It looks like the quotes are around a consistent set of columns, in your example. If that's so, then OpenRowSet with an XML-typle configuration file should be able to...

From what you're describing, you can achieve that pretty easily with a pivot table, either in SSRS or in Excel.

You could probably get exactly what you want with a CLR data type. Those can have pretty much as complex of rules as you want, at the cost of...

There's more to it than might meet the eye at a glance. There are the obvious violations of normal form, data typing, etc., but how many will even check,...

Greg Edwards (4/23/2009)

---

Bob Hovious (4/23/2009)

---

My topic would more likely be... Laughable SQL

Why isn't there an SQL equivalent to Iron Chef? That would make for an interesting competition. ...

That works too. Lower ROI (due to paying for 2 upgrades in 2 years instead of 1), but potentially lower risk.

That error comes from the table, not the proc directly. Check field sizes in the table.