Monthly Archives: February 2011

Do SQL Server statistics get updated during a restore–is this a myth?

I have heard this from a couple of sources but never found any solid documentation to support it.   Does the restore process contain some mechanism to update statistics?  On the one hand restore will upgrade a database so it seems … Continue reading

Posted in Database Administration | Tagged | Leave a comment

The Excel Connection Manager is not supported in the 64-bit version of SSIS

As most new PCs are shipping with a 64-bit OS this is becoming a more common error.  I always forget how to resolve this and have to look it up so I thought if I wrote about it in a … Continue reading

Posted in SQL Server Integration Services | Tagged , , , , | 54 Comments