I use Visio: http://office.microsoft.com/en-us/visio-help/reverse-engineer-an-existing-database-into-a-database-model-HA010115485.aspx

If I did that, I'd be fired. If you don't know why the index...

Lynn Pettis (4/17/2012)

---

Simple answer, it depends. It depends on...

My first question is how much data do you have (how many pages)? If it is small, you will not be able to reduce fragmentation. ADD: Fragmentation is also irrelevant...

Banana-823045 (4/16/2012)

---

Thanks Jared & Gail for reassurance. I'm fairly sure I do not reference constraints in anything permanent.

Jared - In MySQL, to drop a default constraint, the syntax is...

My guess is that data is not actually there. How do you know it got refreshed? Can you use a SELECT * and verify that the data is...

Shouldn't hurt anything unless you have something querying a specific constraint name for some reason. They have names so you can add and remove them easily. I don't like to...

Did you add them to it? They are not there by default. You have to add those counters to your monitor.

Sure! You could install it on a domain controller/web server/application server/media server/any kind of server combination you want. The question is, why would you want to or why would...

In my situation, and now that I know the OPs situation... This will still have to...

Lynn Pettis (4/16/2012)

---

SQLKnowItAll (4/16/2012)

---

In something like tic-tac-toe, chess, or checkers moves occur asynchronously; i.e. team a, then team b, then team a, etc... This is not the case in...

If the databases are identical, wont you potentially get primary key violations on the single...

In something like tic-tac-toe, chess, or checkers moves occur asynchronously; i.e. team a, then team b, then team a, etc... This is not the case in football (soccer for...

And still get an error...

Jeremy... (4/16/2012)

---

Thanks for the help so far. I am essentially trying to show the expiration date for an item, however, when the value is null, this means the license...