You wouldn't happen to have an EMC link that mentions this?

That makes sense. Thanks for the explanation. I'll stay away from the recommendation our SAN guy is making about utilizing LUNs. Better safe then sorry.

Dave

I'm still not understanding how LUNs impact a SAN. Figuring out tempdb loads is the easy part. Understanding the mechanics of a SAN and how that compares to...

But what about my LUN question? We have SAN experts in-house, but their experience pertains to configuring a SAN for file systems, not SQL Server. I can call...

On our SQL Servers we only use SAS drives that are 15k.

Does anyone know of any good links that explain the basics of SAN technology? I need to better...

I'm certain I read something like that for SQL 2000 years ago that made me believe it was a one user edition. Our other DBA thought the same thing...

I think I misunderstood, and this is going back a few years, how developer edition is used. I always thought it was a stand alone license for a single...

The problem appears to be either a bug or very poor code on the part of Microsoft. When scripting object and user permissions with SP1, the options available are...

Thanks everyone

Yep. Thought about that, however I like to maintain the permissions in a separate script during certain migrations.

We found what appears to be a bug with Management Studio that...

I forgot about the DMVs. Thanks.

Good to know Task Manager works with 64bit.

Thanks, Dave

Some of the decisions Microsoft made with 2005 I just can't understand. In 2000 we have the ability to do this, yet it appears this functionality has been removed...

I'm more concerned over the function of SQL Agent - Job Manager, since that was the first resource blocked and within a few seconds of the blocking our server became...

I understand now. Since I am using AutoGrow is it then nearly impossible to control extent fragmentation? And if so, should I ignore extent fragmentation and concentrate on...

Thanks for the link about the shrinkfile impact on fragmentation. I did not know that.

I'll keep researching the Extent Scan Fragmentation issue to see what else I can find.

Dave