Steve Jones - Editor (4/7/2010)

---

Not my job, but I did work in a nuclear plant where we had an old HP that used tape reels and had to load that...

No celebrations for me until we hit 20,000.

rambilla4 (4/6/2010)

---

Thank you mangeshd,

Each disk has 150 spindles in it. So what ever the value I gathered from Perfmon for Avg Disk Queue length should be divided by 150 right?

and...

YSLGuru (4/6/2010)

---

Does anyone know where in BOL or somehwre else like MSDN, one can find detailed explinations on the 4 various metrics tracked by SYS.DM_DB_INDEX_USAGE_STATS , specifically the colimns/fields

User_Seeks,...

For the period you're covering, the answer is yes. That still doesn't say that the day before you started or the day after you stop, some query won't come along...

I suspect pretty strongly you're looking at maybe 30% cross-over. Chapters 1, 4, 5, half of 6, half of 7, 9, 10, are all going to be pretty different...

Either of those options could work. You might also look at using the model database. Create all the structures and code there and then automatically get it deployed any time...

Pretty much any method for moving data will work. If you're trying to practice an enterprise approach, I'd suggest building a full SQL Server Integration Services (SSIS) package and do...

As far as I know, yes it does.

rambilla4 (4/6/2010)

---

On a san, assuming it's properly configured, what you're seeing as "disks" in your OS and SQL Server should be, not a single monolithic disk, but a whole bunch...

It doesn't sound like a trigger is what you're looking for, especially since you're trying to check for a negative, rows that have not been added to the table. Since...

I'm unaware of any systemic issues with Server 2008 R2. Were any other changes introduced to the system? I'd suggest drilling down at the OS level to see what might...

Yes, I definately recommend running server side traces to capture query calls for performance metrics. But be careful here. Don't run the SQL Profiler GUI against your production systems. You...

It sounds like you're just getting started working with databases. I'd suggest a few things. First, be sure that you're not doing these experiments and learning tasks with your companies...

rambilla4 (4/6/2010)

---

Hi,

We have SQL Server 2005 EE x64 with SP3 and have the storage on SAN with RAID 10 configuration

and have the below drives:

C- OS

D- Data

E- Log

T -TempDB

Z- Backup

Total...