I learn toward Erland's last suggestion. Another schema.

If you don't want data, I'd say use the native scripting features to script the database and build the objects (or use something like SQL Compare).

I might still do this...

David In BC (4/2/2015)

---

Every time I go to a Datastax-Cassandra event, I keep hearing about the "legacy RDMS" and how NoSQL, and Cassandra specifically, are going to do them in.

After...

I'm not sure it's one way or the other. Does SOA work for banks? Probably not for some things, good gor others. It's really a decision for building a strong...

You never lose points. Only miss out on gaining them.

SPs have tended to be low risk. There's a chance they fix a bug you've built a workaround to and that breaks, but usually they've either worked well or the...

One other thing you could try is a small table (or series of tables) that give the oldest valid date for a table. Then join to that.

In other words, if...

Yet Another DBA (4/1/2015)

---

Hmmm, I think "DevOps" is one of those terms that has different meanings for people. To me its where Developers have access to the live environment...

You are welcome, and good list. The one thing I might add is to run through specific steps, or use a trace from the 2005 server and execute this against...

Smile

Not me, I wrote a legitimate script for today's knowledge share.

You do or Prompt does it for you?

BTW, we had a scrimmage last week. Went 1-2 with a walk, but tweaked the left elbow throwing. Switched to right handed play and may be there the season. Actually,...

Ray K (3/31/2015)

---

So is anyone as excited as I am that baseball season starts in a week? :hehe::w00t::-)

EDIT: And to add to the fun, anyone have any bold predictions for...

GilaMonster (3/31/2015)

---

Ok, the 5 times I've been to Paris...