Every time I get these "Hey, let's build a database that doesn't have referential integrity/indexes/normalization/mirrors our objects/only stores unstructured...

Excellent list and great set of suggestions. I'd suggest an exchange, already covered by others. Yanke the DTA and put PowerShell up in its place.

The DTA is just way...

GilaMonster (3/8/2010)

---

8 on SQL 2000, 24 on SQL 2005+. 1 or 3 extents. Below that rebuilding the index will just lead to more mixed extents. Above that SQL will use...

I think I understand the question.

2. Yes, it's certainly possible to add a unique constraint to table 2. In fact, you should. Too many people rely on the ID column...

An 8 table join is not going to kill performance assuming the query is well written and the indexes are properly structured. A 40 table join won't kill performance (trust...

Although, below, I think 8 pages (or is it 3, I've forgotten), SQL Server can't defrag the index at all, let alone will defragging an index that size give you...

I've tried finding that kind of work in the past and never was able to either. The few hits I have received came through networking with fellow DBA's. They're the...

WayneS (3/5/2010)

---

Grant Fritchey (3/5/2010)

---

I recently interviewed at a company where it was made pretty clear, just how little I know. You're only as good as your experience and the information...

Jack Corbett (3/5/2010)

---

GilaMonster (3/5/2010)

---

When you're bidding for work (consulting), a collection of...

Roy Ernest (3/5/2010)

---

The top level Grant guy we are talking about is a scary one... 😛

Yes true regarding the knowledge base. I know nothing about BI, I have done only...

I don't know who this top-level Grant guy you're talking about is.

I recently interviewed at a company where it was made pretty clear, just how little I know. You're only...

If you're trying to simply identify the objects, sure you can use straight TSQL, but if you're trying to generate scripts, you really need to look at some method of...

Jack Corbett (3/5/2010)

---

For those not on Twitter, I passed the 70-432 Implementing and Maintaining SQL Server 2008 exam yesterday. Easier than I thought it would be. If...

I think this really comes to down to personal preference and/or experience. Here's my 1.5 cents:

I am not certified. Based on my current job, salary, experience level, and experience interviewing...

It doesn't sound too mysterious. You say you get bursts of inserts over time, and these bursts can cause page splits or whatever within the index and while things are...