I'm not even seeing the logic between the 3 columns of the original data and the rows that appear to have more than three values.

Please post your table DDL and...

YIKES! I forgot about mentioning this. NAS shares, SSIS packages saved on the File level...

I wish. Corporate set up the mirroring without a witness server. @=(

I think it would help us to know what your replication set up is.

What type of replication?

What is the latency / timing?

Approximately how many subscriptions do you have...

Our business has 2 data centers. We replicate every single backup (including the system DBs) to the other data center. If we lose the server, there are two places we...

I have some pretty bad news for you. Rebuilding the indexes will reduce fragmentation, but will increase the...

If you are not regularly backing up the transaction logs, the log won't free up any space. It will hold onto all the space it has...

Or a situation where...

Matt,

How is your console app...

So far as I know, explicit transactions vs implicit transactions will not affect how the transaction log grows. Here are a few links to read up on.

Transaction log basics

Managing the...

My advice is get to know what the business currently has set up (databases, data -- the why and wherefore of it, and business rules). Then see if you can...

Mark Harley (7/23/2014)

---

Sorry, we're using a table variable and not a temp table. You can't add an index to a table variable, can you? We are pulling additional...

Not to provoke debate (but I'm gonna anyway @=), I generally use surrogate Identity columns as singular, non-composite PKs because if I used natural composite keys, I'd be including half...

Give the man a cookie for doing the actual math work! 😀

Mark Harley (7/23/2014)

---

My event data actually comes from oracle and is stored in a temp table, which I believe means that we can't add an index to it. And...