Keith Mescha (12/9/2010)

---

I have this solution partly implemented. I have recently upgraded quite a few servers to Windows 2008 R2 and SQL 2008 R2 and just found out that the...

Holy crud. This is excellent stuff! Well done. I don't think I've seen it all put together quite so succinctly. Thanks.

You don't necessarily want...

I would if I could. I have to go into the GoDaddy...

Jack Corbett (12/8/2010)

---

GilaMonster (12/8/2010)

---

Jack Corbett (12/8/2010)

---

Hey guys, I don't see any threadizens on the list of submissions to SQLRally yet! What's taking y'all so long. There isn't any...

Jack Corbett (12/8/2010)

---

Hey guys, I don't see any threadizens on the list of submissions to SQLRally yet! What's taking y'all so long. There isn't any of you that...

I can't say, absolutey yes, or absolutely no. It's probably worth the experiment. But, remember, as far as indexing the view goes, you can only create that cluster. If you...

Then you're going...

No, that's manipulating the Management Studio UI and it isn't possible. There is not "folders" within the database to differentiate between tables, etc., anyway. If you're trying to control storage,...

When do you think it might be appropriate to denormalize?

Do you have a baseline of existing performance on the server? If not, define "slow"

Basically, you set up monitoring to collect information about the system. Based on that information you might set up alerts, emails, etc., in order to proactively respond to situations on...

Yeah, I'm looking forward to that one...

It really depends on the queries being run against it. As it currently stands, any filter against the view will result in table scans. Actually, as it's configured, any query...

That's a big topic. I'd suggest you take a look at this book (it's a free download) on Team Development[/url] from Red Gate. I wrote the chapters on source control...