Tuning queries, designing better databases or models, import/export in custom formats, finding patterns in data, or...

The AdventureWorks files aren't files like Word or Excel. These are databases. You cannot browse them. They need to be attached to the SQL Server instance in order for it...

I hope not. I don't love...

Interesting. Didn't know that was broken. I'm sure this isn't on purpose. Have you reported this on Connect?

What's broken? It seems to work for me.

LocalSystem is local to the machine. You need an account that has rights to get to the network.

You should set a service account that's a domain account, with Everyone...

Custom encryption should use industry standard algorithms. You can search for blowfish, AES, etc. or use the implementations that are build into Windows. As Miles noted, it's not that hard....

Bonds, Clemens, Sosa, Franco, Piazza, Schilling, Lee Smith

maybe...

I don't know when/if this will be available. It certainly would make some sense, with overrides from the DBA. There are indexes that are lightly used (in frequency), but very...

Why can't you increase the space? Make the file bigger or add a new file or filegroup.

You might also read this about choosing your clustered key: http://www.sqlservercentral.com/articles/Indexing/68563/

you could build a clustered index and then drop it again to clear things up, but really you ought to consider adding a clustered index and leaving it there, as...

brian.francis (11/29/2012)

---

I agree that the managers don't need the technical details, but a discussion of what options are available and what is most appropriate for the situation is critical. ...

cfradenburg (11/29/2012)

---

Based on my experience I'm not sure that I agree with the, "managers shouldn't know," part of this. I fully agree that they shouldn't be the decision makers...

Koen Verbeeck (11/28/2012)

---

At a SQL Server conference I was speaking at two weeks ago, I met one of the co-founders of lessthandot.com/[/url]. Later that day he asked me if I...