Being very much a SQL Server novice, take this with a grain of salt.

From what I've read here, it seems the consensus would be to license ALL features to all...

Thanks for the idea!

I hadn't thought about setting up multiple instances (there's a reason I consider myself a newbie DBA;-) ) but that may be more "elegant" than my hack...

Thank you! I'd not looked at the History Cleanup task, so I didn't know what it might do (yes, I'm rather new to managing an SQL Server, and don't...

I currently fall into a similar situation at my employer. I learned the hard way, that I am not a "manager" or "supervisor" sort of person, I just don't...

Interesting article, it pointed out to me some areas where I need to do some work, before I can call myself a DBA...

Yes, I'm a novice at this, despite doing...

I'm lucky in that I work for a small company, who's willing to reward hard work and effort. Not necessarily with bonuses, but sometimes with out-of-band pay raises, or...

It wasn't "25" files, but ".25" (point 25) files per core.

Here's one of the places I found the recommendation, look...

Steve Jones - Editor (11/19/2009)

---

SQL Server will not spread out to these files automatically, though if they're in the same filegroup, SQL Server will use the space in a proportional...

The recommendation I saw for TempDB was 1 file per core.

Did I misread?

Thanks,

Jason...

The issue I've got is, I need to backup directly to tape for now, as the backup software that was purchased with the server went south (and the client doesn't...