Thought the same thing myself, found out you can assign a drive letter to the mount point, then CrystalDiskMark will see each of your mount point, provided of course you...

Best practice guidelines for tempdb (both 2005 & 2008) clearly states that tempdb files should be of fixed size, one per cpu (max of 8, diminishing returns with more than...

Agreed, I third the motion… 😉

In MHO, making a change to the underlying table structure is NOT a workaround. (period!) Therefore, the only "workaround" solution is to change the select statement. 😉

DBCC SHOWCONTIG...

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use...

been using LiteSpeed for about a year now... works as advertised!

10:1 compression, or there abouts... your mileage may vary...

easy to use interface...

has saved me a few times... for me,...

what is the memory utilization on the server?

what is the status of maintence jobs, you should be able to see the status of any jobs run via the Event Viewer...

regarding the .mdf file... yes, checking the properties shows when the file was created, the "Modified" and "Accessed" times will coincide with the last time the SQL Server was restarted...