Active Directory needs to have a trust  relationship with the other domain in order for the two domains to trust any connectivity.   Google that, and consider whether or not you...

Without a specialized data comparison tool, this is NOT an easy task.   T-SQL doesn't really have much for data comparison on a column by column basis.   While you can use...

You already have code that does the job, given your table structure.   SUM() and AVG() are designed to operate over any number of rows, and not over some number of...

I'm not aware of any setting that will bypass that kind of security.   Also, ask yourself this question:  Would you want spreadsheets that are "protected" to be so easily compromised?

And just assuming that you have your data files properly described, the error you are getting clearly indicates that there's data in your file that doesn't fit into your data...

Nice ideas, folks.   Currently, my code runs in ~20 ms (in my environment) when splitting a 61K varchar(max) value into 8 chunks, and at the moment, that's a bit less...

My gut says a calendar table in your database with a bit column for holiday or not and indexed on that column then by the date, could have rows between...

You may need to specify the correct collation for every individual column, if it differs from your database default collation.   Not sure if there's a method to specify it for...

OPENQUERY or OPENROWSET can at least limit the amount of data that has to traverse the network to your local server from the linked server.   The important thing to recognize...