Yes, Merge is better than Update From. I didn't notice this was 2k8 or I'd have mentioned that too.

One of the comparisons I found, http://dev.mysql.com/tech-resources/articles/move_from_microsoft_SQL_Server.html, by MySQL's Dir Product Mgmt, is pretty fair about the comparison. He admits there are features MySQL doesn't have and won't have...

I'd take a dev copy of the database, on separate hardware, and try a few different partitioning schemes on it. You'll get workability and performance answers that apply to...

Other than joining them together, the only thing I can think of is using Union to hook them together, then using Pivot/Unpivot to get them in the form you want....

Jeff:

I did a speed test like this:

SET NOCOUNT ON;

go

IF OBJECT_ID(N'tempdb..#Strings') IS NOT NULL

DROP TABLE #Strings;

IF OBJECT_ID(N'tempdb..#T1') IS NOT NULL

DROP TABLE #T1;

IF OBJECT_ID(N'tempdb..#T2') IS NOT NULL

DROP TABLE #T2;

IF OBJECT_ID(N'tempdb..#T3') IS NOT...

All the data on backups in your server is stored in msdb, in the system tables named things like "backupset". There's a column in msdb.dbo.backupset called "software_vendor_id", which will...

GilaMonster (1/4/2011)

---

Missed it when Steve cleaned up. Someone enlighten...

Do you have specific questions or problems you're running into?

I see some tables, and some procs that access those tables, but I can't tell what the business rules are for...

Sometimes, with 3rd party software, you really don't have the option of making it be sane. Some of it, often from the biggest software companies, ones that really should...

Just keep telling yourself "It's a common mistake. Any plonk ... anyone could have made it." You'll feel better. :hehe:

Honestly, it is a common mistake. It usually...

If you set a max file size, and it runs out of space, it will crash and burn to one extent or another. It's usually recoverable, but it will...

Ah. No, don't modify the function. Take your original query, and use the function instead of your Upper/Lower pieces.

Lowell posted an example a few posts back. Take...

Brandie Tarvin (1/4/2011)

---

Oh. Hey, let's use that as a springboard.

What types of articles do you like best? The kind that are most "talk" and little code, the kind that...

Rebuilding indexes takes space in the file, unless you specify doing the work in tempdb (check the documentation on rebuilding for the option for that). Once it's done, it...

Just put the column name in there instead of the variable.