What kind of things have gone wrong with this so far?

What kind of things do users have attention on? What do they ask about? What do they like?

Were...

While I normally avoid them, I think this may be a case where a cursor is your best bet.

I'm not clear on what you're asking.

Do you mean you have a local copy of the database and it runs index rebuilds slower than the server copy?

You can load multiple files into multiple tables in one SSIS package.

Wayne West (6/3/2016)

---

drew.allen (6/3/2016)

---

Wayne West (6/3/2016)

---

I don't always drink beer, but when I do, I put a semi-colon in front of it. 😀

This is why I like Mladen Prajdic's SSMS...

Windows Server 2012 Standard has full features, but only allows 2 virtual instances on a license. The number of virtual instances is the only difference, per https://www.microsoft.com/en-us/server-cloud/products/windows-server-2012-r2/Purchasing.aspx.

So it shouldn't...

I would approach this kind of thing as a Regex and use CLR functionality for it.

Why not have a single Product table, and have the Company A and Company B tables map to it? Then competitor products could map to it as well. ...

The correct answer is "none of the above".

First, semicolons don't terminate batches, they terminate statements.

From TechNet: "A batch is a group of one or more Transact-SQL statements sent at the...

It says the error log location can't be found. Take a look at the settings, see if it's able to map that.

I'd start by looking at the execution plan, and by checking for blocking issues.

A "recursive CTE" will parse through that kind of data. For your example, this works:

WITH rCTE

AS...

ZZartin (5/31/2016)

---

GSquared (5/31/2016)

---

David.Poole (5/27/2016)

---

If you turn up to an interview as Britain's worst presented compost heap then more fool you. You don't know who you are going to meet,...

Not on the original topic, but relevant: The day I discovered I could Merge into a CTE, and thus limit the target rows with whatever Where clause I felt like,...

David.Poole (5/31/2016)

---

Obviously I agree on the...