PaulB,

I agree about 1:1 tables, there are not many times I go for those. As for the surrogate vs. natural discussion, it depends..

CEWII

I'm with SQLRNNR on this, log-shipping or mirroring to other machines in the same cluster doesn't do much for either high-availability or disaster-recovery. With that said there are other...

There is a certain accomplishment in building one. There is more to it than I originally thought and it took a whole lot longer to build and debug than I...

As a side note I am planning on support for SQL 2000 and above and all editions. 2005/2008 support is usually the same, 2000 sometimes requires mods.

CEWII

I use some CLR in the SSIS packages but not much otherwise. There isn't really any need to use SQLCLR for this. I generate a list of servers and...

Using very little dynamic SQL, my solution is SSIS based. And no linked servers, which are not stable enough for my purposes.

CEWII

I'm not sure that PBM is the right answer. Its a good way to verify that servers are in compliance with policies but I haven't seen it as a...

It is very much a debate.. I tend to prefer surrogate/artificial keys. Business keys tend to change over time and while they are definitely needed, but I rarely...

No problem, have a good weekend..

CEWII

I'd go with developer, it IS Enterprise Edition in every way that makes any difference. If works just fine with VS2008 and I've had no issues with VS2010. ...

It is the RIGHT OUTER JOIN. Re-writing queries that use outer joins can be tricky. Once you have it looking like it should make sure that it returns...

So you have an 8 column composite key? Yikes..

First, I probably wouldn't use MD5, the collision domain is to small for this purpose, how about SHA1? MD5 is basically a...

sqlfriends (5/27/2011)

---

I have a couple of questions about the SQL server licensing.

I see on microsoft site FAQ:

1.

Q. Do I need a separate license to run the SQL Server...

bopeavy (5/27/2011)

---

Elliott

With that said if node one is active and node two is active and node 2 is the fail over can I use the node 2 for log...

I don't think we can..

You have to drop and recreate it. Sorry.

CEWII