One point that has been neglected is the ability to use mdx, ProClarity supported this. Briefing books was another major choice factor, this is a feature where snapshot views of...

Disk and raid info is quite easy, most sql server books have good chapters, e.g. MS SQL Server 2k admin companion, inside SQL Server, sql server unleashed. Neil Pike has...

You can restore a backup to a different database in EM, edit details and force overwrite, or in TSQL, in BOL. If you have the mdf & ldf files you...

I'd be worried if any of my servers were sitting on 100% cpu. !!! Are your users experiencing wait/timeouts or are you just noticing your server isn't beeing driven flat...

We evaluated most major tools against analysis services and chose Proclarity, super product and very powerful. Users seem to take to it very quickly.

The answer is yes and no, there is a bandwidth limit , say 160Mb or 320Mb dep on the scssi bus but to be honest your chances of exceeding it...

I think SAN's are a bit of a black art and "must have item" regardless of their good or bad points with SQL Server. I've never found a SAN to...

we just interviewed a potential DBA who had just passed his mcp for w2k server ( 2 weeks ) he didn't know how to configure w2k to allow sql server...

You don't really gain from creating partitions/volumes across the same set of disks because no matter how you slice and dice your disks each is limited to a number of...

Surely the best option is not to use sysmaint <grin> ? It's an interesting point however, does it apply where there are indexes on single columns that also appear in...

The maint plans tend to be difficult to fault find when they fail - the usual error reads " sysmaint.exe failed " Very useful!!

I'd advise not to use them -...

I seem to remember an undertaking from microsoft that they would not withdraw a version of SQL Server until the next two versions were released .. e.g. not drop 7...

it's number of transactions .. to see throughput you'd really need to measure pages/sec or throughput on the disk system in read and write bytes/sec

hyperthreading works fine with sql server .. used dual zeon 4's on dell servers with sql std no probs .. shows significant performance gains .. never though about turning it...