Read this: http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-1230-tempdb-should-always-have-one-data-file-per-processor-core/

In general, here's what I'd say. Separate LUN if possible, but not critical. Go with # cores for <= 8. After that, stick with 8 unless you can...

It's a balance.

Can you afford it, does it cause issues, what does this do to your life. Balance the joy/excitement with the costs. The real costs, not just financial ones....

Steve Jones - SSC Editor (8/8/2013)

---

jasona.work (8/8/2013)

---

Now nobody's trying to talk me out of this...

Hmm, pay off bills faster (albeit not a lot faster) or a new "budget" mid-life crisis...

One is smarter, financially, but...

You shouldn't have that many processes that work in the same area, without knowing what is being done with each. Even in large development teams, 20 people, I haven't seen...

First, you need to change terminology. Worktables are intermediate tables used by SQL Server. If you refer to tables you create as worktables, it becomes hard to discuss performance related...

Dick Cooman (8/7/2013)

---

I support a 2TB database that is the backend for a key application in our business. As it is vendor designed, I have little say in the...

SteveHood79 (8/7/2013)

---

I have my blog syndicated through SQL Server Central. The problem with blogging is that there's no feedback on if you're providing a useful service or if people...

Koen Verbeeck (8/7/2013)

---

BrainDonor (8/7/2013)

---

GilaMonster (8/6/2013)

---

The...

Stefan Krzywicki (8/6/2013)

---

I'm going to be working on a website that is currently on a Linux machine that has HTML, CSS and some javascript. The site needs a database. If...

Koen Verbeeck (8/7/2013)

---

It would be nice to have some feature on the forum that allows a topic to be "answered". It doesn't need to be tied to the points system,...

Phil Factor (8/7/2013)

---

What about catering for those of us who like to spread it all out across the screen to have a web-based version of the newsletter that...

Sarus1984 (8/7/2013)

---

Hey Steve,

multiple newsletter formats to choose from could be great - and if you give the option not only to choose the format but also which block of content...

paul.knibbs (8/7/2013)

---

Steve Jones - SSC Editor (8/6/2013)

Yes and no. We can allow test to flow, but then layout looks funny at times. If we control it more, we can't easily...

raadee (8/7/2013)

---

I really like the looks of the database administrators newsletter that Stackexchange sends out that contains information

about forum threads. The choice of topics that they made makes it interesting.

They...