The basic information can be found from right clicking on Computer/My Computer and going to properties, then reading the Processor information.

You can get more detailed information from something like CPU-Z...

I think Gail's right here, there's virtually no off the shelf hardware that supports 16 sockets. Are you sure you don't mean you have 16 cores? E.g. 4 sockets with...

Hehe, I must have worked in some different industries then. 😛

There are obviously some industries/applications where it's important to throw thousands of man hours at each windows security update...

Tread with caution using binary_checksum. E.g. with 10 bit columns (1024 distinct combinations), there are only 256 distinct binary checksums:

WITH a AS ( SELECT CAST(0...

Ok. I've had a brief look, but don't have time to do anything too in-depth today.

Some general points:

1) Uniqueidentifier makes a very poor choice for a clustered index as they...

Also, why are you wrapping RTRIM's around columns? That means that indexes can't be used to perform a seek. You really should be cleaning this data on input, but even...

Also, peppering your code with NOLOCK is risky at best. I'd have a read through here:

http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx

And consider whether you really need these and are prepared to accept the consequences in...

There's a lot of low hanging fruit here. Can you post the DDL for all the tables involved and preferably a few rows of sample data (doesn't need to be...

I think even the best of candidates have blind spots.

I still cringe about early on in my career, I routinely truncated the transaction log as I was self taught...

Do you need the value from this field if it's non-numeric? If you go to the error output of your source, you should be able to set it to ignore...

You're probably posting in the wrong place and a .NET forum is likely to yield more specialist advice. In terms of SQL Server, with the exception of complications to do...

Why on earth are you using a script task to do this? The SSIS data flow task is specifically designed for taking data from a source and putting it into...

If you really need the sum of both numbers to be unique, rather than a unique combination of the two columns, then yes, you would need to create a 3rd...

You didn't answer whether you had any error outputs set to redirect rows.

How long is this extract taking, how many rows are there in total and how many are missing?...

There's not enough information here to provide a solution. As a wild stab in the dark, are there any error outputs that redirect rows that don't go into the destination...