Steve,

Most places I've been try and minimize the number of service accounts, so typically they would use a sqlservice account for a couple of production servers and a separate account...

Brian,

Awesome article!

Most of the apps I've worked with use an intenal security mechanism and connect to the DB via 1 application login...

I think application roles have thier place, just...

VMWare is great for non production DB servers - uat and test and the like, most of the installations I've seen for Production servers are just too busy to be...

James Stover (7/22/2008)

---

So I went back and re-read the eWeek article Steve linked to in his editorial. It's a very one-sided piece, don't you think? "Here's what CIO's measure their...

It's been my experience with larger tables it makes sense to drop and rebuild... the inserts go alot faster without having to deal with the indices. Guess it depends...

Good point! I always try to ask 'thinking' questions whenever I interview a candidate to get an idea of how they think.

Long-standing relationships are the way to...

It's a good article... first thing that comes to mind is disabling for an ETL process, but since you'd have to rebuild anyway, you could get the same result from...

sbateman (7/17/2008)

---

remember you can use tempdb as a nearly normal database**

I create Structure for XML explict table and error_log table in tempdb and JOB-Agent bcp's these to files.xml

Their STRUCTURES/Programmes are...

There is a script to migrate the logins from the old server to the new server.

http://support.microsoft.com/default.aspx?scid=kb;en-us;246133

You need to bring over the logins info including SID's which are part...

I think there's a sproc out there called sp_spaceused if that's what your looking for?

Greg Larson wrote a script a while back.. uses xp_fixeddrives

It would be nice to see some real-world examples where they would prove to be useful.

I suppose if the values in the table were generally null and only...

Nice work! Your article was very informative!

Excellent question! So many SQL developers don't understand the difference between isolation levels and the impact of using them!

Seems like there's a call for it.... I can think of alot of instances where that would come in handy.

You can use SQLIO to verify the disk speeds and check the throughput.

It's available on Microsoft's site.... it's pretty non-intrusive other than using CPU and DISK for a...