Jeff Moden (1/13/2011)

---

Stefan Krzywicki (1/13/2011)

---

Maybe other folks will leave it, but I'll stop and pick it up. I've...

Tom.Thomson (1/13/2011)

---

OK, so Merge gives an error message, which is certainly a good thing (it surprised me, because reading the MS documentation I didn't spot that; but with hindsight it...

That depends on who has access to create objects and run scripts in that database, and what rights they have. If, for example, you set the database to Trusted,...

Are you doing range scans on the indexes, or just seeks? (There are DMVs that tell you that.) If it's just seeks, then fragmentation won't matter much.

I'm pretty sure I've always seen them as single blocks of spaces on a drive, not fragmented all over. But that might be an artifact of how they're set...

Do you have a Numbers/Tally table?

If so, this is pretty easy to do.

select *,

substring(LargeColumn, Number*255, 255) as SplitColumn

from dbo.MyTable

inner join dbo.Numbers

on Number <= len(LargeColumn)/255;

lnoland (1/13/2011)

---

I thought, perhaps, that...

Okay, I found the same thing. Merge doesn't "avoid" or "fix" the problem, it just explicitly makes it clear that there's a problem by raising an error.

Honestly, since it's...

Trustworthy on a database essentially means exactly what it says: the code in the database is "safe to execute". You've verified it, and you're telling the engine that it's...

For all practical purposes, the clustered index IS the table. If you update anything in the table, it has to update the clustered index.

Stefan Krzywicki (1/13/2011)

---

Steve Jones - SSC Editor (1/13/2011)

---

Stefan Krzywicki (1/13/2011)

---

They're trash money at this point. If people see money on the ground, they stop and pick it up. If they...

Merge and Merge Into are the same in T-SQL. It's like Insert Into.

I'm seeing a lot of confusion on this subject when I look around the web for it.

Personally, I'd set up a testbed and try out some options on it. ...

Eric Russell 13013 (1/13/2011)

---

GSquared (1/13/2011)

---

...

Legend has it (might be true) that there was a guy who, in the 1930s in the US, became certain that war was going to break...

Anything else I can think of involves basic database refactoring. Like partitioning tables instead of archiving, or even more complex solutions.

I think modifying the triggers is going to be...