We recently switched all are servers to use SQL Lightspeed for backup and restore.  The main reason we did this was for compression.  It was taking to long for our...

SQL server does favor clustered indexes since they are read 64k at a time instead of 8k at at time and the main table data is also sorted. 

However, if the clustered...

It may be because the data needs to be sorted based on this column, which is why it is clustered.  The additional non-clustered index may have been created to enable...

It is interesting that Microsoft is a Crystal partner and bundles peices of Crystal with VB.  Microsoft is also denying that SSRS is a direct competitor against the Crystal product. ...

Crystal is probably the most popular and mature report writer for VB.  We use it and have had good luck with it.  If I were starting from scratch, I would...

Microsoft released reporting services early since it was suppose to be a part of Yukon.  The early release does not have the full functionality that it will have when released with...

Reminder: 32-bit DTS is not supported on a 64-bit box. You will need a 32-bit machine from which to run your tools.

CynicalDBA, I read a review that said dts...

We had about 1% of our queries run slower when we upgraded to 2000. Setting the multi-processing to 1 by using the maxdop option fixed some and reworking the...

If auto update statistics is on, will the statistics get updated when a reindex is done? I think the auto update statistics only kicks in when the data pages...

I am using sql server 7.0 and 2000.

thanks.