Microsoft Bob

NOTE: The views expressed on this blog are my own and may not reflect the views of Microsoft
Posts
  • Microsoft Bob

    SSIS – Chunking number of inserts with a For Each container

    • 1 Comments
    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...
  • Microsoft Bob

    Using Checksum to create random data sets

    • 0 Comments
    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...
  • Microsoft Bob

    Managing Index Fragmentation and Compression

    • 0 Comments
    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...
Page 1 of 1 (3 items)