OK - you're a bit stuck if you can't alter the source tables. Worst case you have to do the brute-force column-by-column comparison. You could still have a win using...

The difference is that you are modifying data by inserting the results into a table. Doing any data modification causes an implicit transaction to be wrapped around the statement, and...

If I follow your description correctly you're using CHECKSUM() comparisons to determine whether a newly imported row is different to the stored copy of that row, correct? If so,...

Yep, agree with RBarryYoung on this one. CLR is definitely the wrong tool for this task - even with his indexer method, in your example best case you're going to...

I'm afraid that's incorrect. Partitioned views are available on SQL Server 2000 - see here for more info: http://msdn.microsoft.com/en-us/library/aa933141(SQL.80).aspx

Regards,

Jacob

Does the connection string on your data source in the report point to a different server than the one hosting your RS reports? If so to use Windows auth...

No problems Sujith,

You can get good read performance from RAID5, so if you compared RAID1 (2 spindles only) to RAID5 (3+ spindles) you would likely have seen improved reads (the...

Are these real LUNs backed by seperate physical sets of disks? If so, yes they should give better performance than having them all on one LUN. However RAID5 is generally...

Don't re-invent the wheel - the ASP.NET supports encrypting sections of the web.config using one of two methods (DPAPI or RSA), using the aspnet_iis.exe tool. Have a look here for...

Small suggestion: maybe I missed a reference to this, but wouldn't the Bit datatype be perfectly suited to the Data Source column (one bit column per source)? No need for...

With only 8 disks on a single RAID controller I'd do the following:

RAID1 OS/swap

RAID1 User Databases

RAID1 TempDB

RAID1 Logs

and backup across the network...

Sorry for resurrecting this old thread, but Vladan do you have a BOL or similar reference for this?:

Vladan (5/27/2008)

---

...Collations with names beginning with "SQL_" cause table scans instead of index...

Please tell me that the reason for changing this field to binary is not a half-assed attempt at "encryption"...

Regards,

Jacob

One very small thing: unless you're going to be somehow running the dynamic SQL string on a pre-OSX Mac(!) I'd use the "correct" Windows CRLF sequence, which is "char(13) +...

This is one situation where a CLR function would do the job nicely. It's got a nice URI object that exposes the various parts of a URL as properties -...