110ms isn't that long, so my initial take, look at sys.dm_exec_requests to see what it's waiting on, probably won't work, but you could try. If it's XML, that run time...

From a structural stand point, they're the same. But, using the system generated keys becomes problematic when you need to support multiple environments for the same database. Let's say you...

Lots of columns, one table... eh.

Try messing with an 86 table join. That's when life gets interesting.

Is your database set to Full Recovery mode? If so, you need to be backing up the log files too.

When you back up a database, it backups up the data...

I'd also suggest reading Books Online. It really is some of the most complete documentation available. But, some additional places to look include, this article that I wrote quite a...

It may or may not be indexes, who knows based on the information at hand. What I'd suggest is taking a look at sys.dm_exec_requests and see if there are processes...

RBarryYoung (8/28/2010)

---

*sigh* Long story, ... between work problems and medical problems I literally have no time for anything else. Don't get me wrong, neither is serious, but both...

You're welcome. And thank you.

You aim?...

Limited is the quickest mode on that, so switching it to Sampled or Detailed isn't going to help.

Are you hitting contention?

Another vote for Tom LaRock's DBA Survivor. Great little book.

Another book about the DBA job is Craig Mullin's "Database Administration." Also worth a read.

Hell, I'm only letting them call me a DBA because it...

Brandie Tarvin (8/27/2010)

---

ACK! We've been invaded! There's one of those non-DBA...

DC - When I was a kid it was the Flash. I just loved the idea of running, really fast. But as I got older I become more and more...

GilaMonster (8/26/2010)

---

I'm seriously considering suggesting Entity Framework, so that I can focus on getting the system integration portion done (will need to extract and load data from 4 systems) and...