Unless there's a very good reason for it, most tables should have a clustered index. Be sure that, even if the database is normalized, it has appropriate primary and foreign...

I'd suggest running a trace while the events are occurring. Collect the data out to a file. You can then import it back into a table on a different server...

The individual users are validated through AD and the group they belong to. So we only have to give access to the group. It is a trusted windows connection.

You're just more diligent than I am. If I can't get it installed, I toss my hands up & move on. Since I've started working exclusively on virtuals when I'm...

My most recent set of beta testing is with the Visual Studio Team System Database Edition. They've got a new release coming out to support SQL Server 2008, but it's...

Is there a question in there somewhere?

A view is just a query. They can be somewhat optimized, but since they usually don't include much in the WHERE clause, there's little that can be done. So, if...

You might want to get the developers to put their database structures into source control. That way a given development database can be rebuilt from scratch. Further, as they start...

We connect AD groups to roles within a database and assign priveleges to the role. It works really well. We just don't get into managing individual logins.

The major shortcoming to...

I'd suggest Itzik Ben-Gan's Inside SQL Server 2005: TSQL Querying. That's a great source for really learning how TSQL works and how to apply it to a lot of real...

Because you guys are running express, you actually have choices. I've got a machine with at least three versions of express from three different third party apps all running side-by-side...

My personal preference is document & fire, but I know that my company will go through counseling, remediation, more counseling, documentation, extra training, heart felt discusions, yet more counseling, more...

Adam Machanic (9/23/2008)

---

Just keep thanking your lucky stars that they didn't choose EF... Here's a thread someone sent...

colin Leversuch-Roberts (9/22/2008)

---

I was told on a couple of occasions that changing the threashold actually doesn't make much difference as the optimiser will over-rule your settings if it thinks best...

Adam Machanic (9/22/2008)

---

Matt Miller (9/22/2008)

---

Agreed. Still - my biggest objection to it is the separation of duties issue. Since we're back to putting what essentially boils down to...