I think it is very important to understand DBCC SHOWCONTIG in SQL2K. Have a read on this topic via the link below. I reckon its good.

http://www.sql-server-performance.com/articles/dba/dt_dbcc_showcontig_p1.aspx

The only thing that...

Ed,

Assuming you've got 2 physical CPU, have you tried to load test and put tempdb on RAID 1 + 0 on a SAN with its own spindle? The transfer rate...

Steve,

I salute your braveness. I would've never dared to do such thing. Probably we're in different field.

My murphy law, the easiest thing could go wrong! Its better to go wrong...

Reg,

Basically the method Noel suggested will flush the TLogs to disk and then shrink the file. Its no difference from issuing a command

backup log <db name> to disk =...

You point sounds valid enough. We’re talking about different situation. So, I wouldn’t say clustering is any bad, its just difference in approach for different purpose.

Just a few...

Gail,

First of you, i think you were right to say filegroups per CPU does not have performance gain. I think i'll have to agree with that now. Well, at least my...

mate,

how sql fills-up user database is also round-robin. The reason why 1 filegroup per CPU is so that each CPU can have a thread to do a job at each...

Jeremy,

Are you sure your performance gain comes from AWE? As far as i know, AWE, PAE and 3GB are not needed for a 64-bit SQL.

I do notice your tempdb obnoxiously...

The 1 file per CPU does apply for user database. But normally i dont follow this recommendation for maintenance consideration. Bear in mind you'll have to create all filegroups to...

I do agree that clustering has its benefit. But for me, its still a single point of failure. Clustering is availability vs DM is redundancy. I don’t...

Hi Cmille,

Part of my disaster recovery strategy are involves using DM. it’s not to say I disagree with you, but I’ve got following reason why I...

Colin,

I dont think there's any way you can access a mirror DB directly as it needs to be RESTORE WITH NORECOVERY in order to set a database mirror.

However, you can...

Any plan to an article about database mirroring + log shipping? I've spoken to M$ and they were saying it is possible to combine both. Example in a simplified situation, you...

Hi CoetzeeW,

There's an undocumented command in SQL2K to tell you which scheduler is processing your spid.

First of all, get the spid that you're interested in. Run the command below...

My organisation is in the midst of upgrading a few identified databases to SQL2005 more for business reasons. I do agree with Steve that from a business and technical perspective,...