Jeff Moden (7/22/2014)

---

What's so bad about using something like BCP to export the data to a central transfer repository and simply import the data at the other side? Rhetorical...

Jeff Moden (7/21/2014)

---

I have to admit that using XML to do such a thing (and, yes, I have send data "over" for the very same reason you've suggested) would be...

I usually assume things like this are simplified versions of much larger concerns. Not everyone's comfortable posting...

mister.magoo (7/21/2014)

---

So is that right? You have a stored procedure that produces XML from data stored in tables and now you want to shred that XML to store the data...

Derive the column after the conversion and prepend the 0x.

DT_BYTES has a max length of 8000, which won't handle your MAX. Since there's a single binary value you shouldn't...

Sorry Goofy, but I have to disagree with the overall preference with your company. I believe a local power user and/or IT resource to allow for business developed small...

Do you have monitoring, baselining for problem comparisons, restore tests, and optimization reviews already in place? If not, you've got your work cut out for you. Best to...

Hit up the second link down in my signature (index/tuning help). It'll show you how to snag and attach the execution plan (actual is preferred). We'll need that...

Reports and/or traces on long running and/or high I/O queries. Mark for review and optimization.

Perfmon bottlenecking. Try to find out if it's memory pressure, CPU pressure, I/O pressure,...

ranmazure (7/21/2014)

---

3 questions about a public university IT environment.

1) Do we 'have' to be SOX compliant? Most of what I read talks about corporations and businesses. What about...

Steve Jones - SSC Editor (7/21/2014)

---

However I think most people don't learn because they don't need to. Not using replication (or SSIS, or Service Broker, etc), why learn it? Not...

@patricia-2 Hartman: Well spoken and described.

If you'd like an idea of how last unread is implemented rather well, check out the Dwarf Fortress forums on Bay12.

http://www.bay12forums.com/smf/

You wouldn't use rowversion via tempdb, not really.

What you'd do is in your CRUD proc, you'd have an additional parameter of, say, @oldRV. You'd then open a two stage...

Lynn, curiousity, why wouldn't you set that to 4,500 rows instead of 10k to avoid table lock escalation?