Jeff Moden (8/8/2013)

---

Right sizing log files and datafiles for the FULL recovery model is a far bigger PITA than TempDB will ever be, IMHO. For example, even if you...

Not sure a...

We have a piece coming next week on CLR procedures and code.

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