2005 comes in four flavors. I would not expect all four versions to be at the same level. So be careful you are not comparing apples to oranges....

I agree with Jeff. Also, if you can, create a circular trigger, where insert into Table A triggers insert into Table B which triggers insert into Table C which...

Won't the triggers also, if not written carefully, result in constantly tripping each other? Server A gets an update, so its trigger updates Server B. Server B now...

What is the end result you seek? A single line with counts for each customer? All the detail captured in the database, ordered by customer (= customer +...

Also, please be careful to include examples with '-', so that we know whether that is the full field, or the '-' is part of the field's value. (Hence...

We haven't done our migration yet, from 7 to 2005, so I can't give a lot of advice, but I would encourage installing ss2k5 in MIXED mode, not relying solely...

Mr. Jones:

Regarding the second point, the argument was that an apples to apples type of performance comparison should be made to 'prove' the relative efficiencies of which RAID is 'faster'....

Have you examined the following articles for assistance (It's amazing what google can dig up when using the following search string: 0x80040E37 SQL Server Error message )?

support.microsoft.com/kb/915799

support.microsoft.com/kb/280106

Also, the 3rd...

'I have a requirement...' - What is the requirement? For a report? For data storage? To display on a web page? The example cited from another...

Gift - the reason for casting to Varbinary was to allow the user to lookup the character and prove to themselves that no conversion occurred.

Aren't we all supposed to be...

So - is it the diseased implication (SSIS has mono), is it the rocky road aspect (..lithic), or is it just that SSIS is enforcing a layer of simplicity within...

I haven't run the analyzer for a while, so my memory is a little fuzzy. I believe I ended up loading the analyzer program locally to the server being...

It's the end of my workday and I'm about to get a phone call from my boss, so I have to make this quick...

subquery: select only those IDs that...

This will probably sound harsh, and it will certainly NOT please management, but requiring your development team to manually redeploy the reports may bring home to them the value of...

When you say from one drive to another, are both of these drives on the same machine? How many connections have to be made between the two drives? ...