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...

Attach is faster. But that really doesn't cover the question. The real question is what are you doing? Are you moving a database from one server to another? Then detach/attach...

To do that properly, so that the user doesn't get access, you need to open up a programming language, VB, C#, whatever, and create an executable.

Otherwise, a simple solution would...

Unless you've done modifications to it (in which case, you really should have a tested backup around that you can restore from) model is generic. Do you have another instance...

GSquared (12/7/2010)

---

Steve Jones - SSC Editor (12/7/2010)

---

Brandie Tarvin (12/7/2010)

---

I have to wonder if this thread is encouraging people to respond more harshly to articles, posts, etc. Certain we've seen an...

No, not at all. The natural behavior of the optimizer is to rearrange the join order, right out of...

I hated geometry, so don't look at me. But even if someone could write the function in TSQL, they shouldn't. It's not something that the T-SQL language is going to...

I guess I'm still confused as to what you're going for, but sQL Server knows which databases it uses to maintain itself. It works with them and there's very little...

Yep, what Steve said. Sorry I wasn't clear. It's a domain account that I was describing without saying it properly.

No, SQL Server should run as an account on your system that has access to that drive. We usually use a common service account for most of our systems, but...

Why do you care? What are you trying to do? If Paul White's script here doesn't do the job, what is that you're looking for?

shaun.turner (12/6/2010)

---

Hi all,

So I don't usually post my problems on these forums as I tend to prefer to find the answers myself but this one has me stumped and I'm...