The discrepancy could also be caused by differing index statistics between the servers.

Getting all possible combinations in a query is usually a mistake. 

In EM, right click the job and select "View Job History..." to see if there are errors.  You may have to check the "Show Step Details" box to see which...

We did an in-place upgrade from NT to AD.  There was no effect on the SQL servers at all.  Piece of cake.

You may also want to use a SQL logon instead of a Windows logon account if you have your DMZ outside of the internal network.  Use an account specifically for...

The obvious next step should have been to split the NAME and VALUE data into two columns.  The table presented in the article would be difficult to query or generate meaningful...

Just backing up won't shrink the transaction log file.  It will eliminate the entries, but not change the file allocation.  Use the DBCC command, as shown above.

I've got a SQL stored procedure that randomly picks a given percentage of records.  I'm looking for both of the items in #2.  The population size is about 5,000, and the expected...