Yes, you could, but if we're talking about a Production system then I would not advise running a Profiler trace because it's going...

Pretty much the same way. Check out this link:

http://technet.microsoft.com/en-us/library/ms189852(v=sql.105).aspx

Regards

Lempster

You could try adjusting the values for DefaultBUfferMaxRows, DefaultBufferSize and EngineThreads, but it's something of a black art....I've found, anyway. Also, minimise the number of 'blocking' tasks in your package...

herladygeekedness (2/17/2014)

---

It's a simple matter to copy/paste these event handlers across pkgs (a few mods needed, not big and time consuming). We can then write queries or extract any...

Yes. for example, if a row is updated on the source and then later that same row is deleted on the source, that order of transactions will be preserved when...

schleep (2/18/2014)

---

And I'm fairly certain transactional replication can't be done, as one of our requirements is that the order in which the transactions are to be applied to the destination...

Thanls all. I think using a placeholder makes sense so that's what I'll do. Very much agree about setting user expectations!

Regards

Lempster

As soon as the new Mirror (former Principal) is back online, the mirroring session will resume and the Mirror will be in a Synchronizing state. All the transactions that are...

Quirky Update?

Something to be aware of (which has always prevented me from using FILESTREAM) is that a database cannot be mirrored if it contains a FILESTREAM filegroup. There are a number...

If you only want a short delay between data being inserted into one database and appearing in the other, snapshot replication won't work for you. (Well, depending on exactly what...

For this particular implementation, i can't think of a scenario where a column purely used to handle a type 2 SCD for a particular attribute would be referenced by a...

Off-topic, but I didn't know...

If only there were some (or even one!). 😉

I agree with your sentiment though.

Just change your expression to [InvalidAreaCode]== "Invalid Area Code" || ISNULL([InvalidAreaCode])

Regards

Lempster