My main customer utilizes SSIS for some SQL and Oracle integration requirements. One challenge they’ve had is timeouts from the Oracle side. We’ve tried everything to eliminate the issue in terms of extending timeout values within SSIS, but...

Here’s a quick tip if you don’t want to try to use random and figure out seed, etc.  If you’ve got a lot of columns in a table, it is pretty likely that the checksum for all those data values are going to be random across your primary keys. I recently...

For today, I recycle bits from a couple of excellent authors in the SQL community. The first script is for optimizing compression. I “borrowed” this from Paul Nielson, author of the SQL Bible. You can visit his SQL Server bible site at http://www.sqlserverbible...