If these are completely different functional applications with no shared data between them, then no, I would not put them into the same database. The sizes you're talking about are...

Yep. Exactly. Nothing hidden there. They are different constructs doing different things.

L' Eomot Inversé (9/9/2013)

---

Grant Fritchey (9/9/2013)

---

Not sure anyone noticed, but we passed the three year anniversary of the thread. Thank the gods the terrible twos are over. Our little... thread......

Also, if the data is that volatile you might be looking at statistics issues on the indexes. How are you doing maintaining those?

Not sure anyone noticed, but we passed the three year anniversary of the thread. Thank the gods the terrible twos are over. Our little... thread... is a toddler now.

Take a look at some of your more common or longer running queries that are using these nested views. Then, check the execution plan, specifically looking at the first operator,...

I'll go one step farther than the others. In addition to scripting everything out and then running a restore, I'd get the scripts into some sort of source control so...

Yeah, you have to do a little work to see the activity in the performance metrics. I outline it in an article here[/url].

For backups I've been using Amazon storage and Azure. Both work about the same. If you do go with Azure, I strongly recommend getting a copy of Cerebrata's file management...

Steven.Howes (9/6/2013)

---

8 out of 10? really? That's insane. I can't believe that many people would try to cheat and screw their employers by taking a job that...

We also use Deployment Manger for our software...

Ha! Couldn't help it. You have Development Manager in the email. Might want to fix the typo on the web.

Remember, it's relational storage. So create a table that defines funds. That single table will have 65,000 rows, each with a unique column that identifies the fund. Then, you import...

I do stuff like that all the time. Let's say we're building a system for storing personal information. You have a table to define the person

PersonID FirstName LastName

With the primary...

Jeff Moden (9/5/2013)

---

Damn. I forgot all about this. I'll get started early next week. According to what Steve asked for in his OP, I'm thinking that I...

patrickmcginnis59 10839 (9/5/2013)

---

Just to reemphasis what I was hoping to relate, I would hope that tests at various skill levels could be just as trustworthy, as its at the skill...