I'm not sure. These are car loans so it might be where a vin number exists twice, but one record is a paid off loan still in the database...

I tested yours with our info and it ran in 1.5 minutes instead of 17 on a test box. But I'll have to see what the developers are trying...

You can certainly use email, messaging, skype etc as well as the phone, but one huge obstacle I've seen is that way too many people just can't read and write...

I have to admit the limitations of email etc and the efficiency of working with people face-to-face. I used to telecommute two days a week, but not at all...

Great discussion and helpful solutions.

1) many of us are a little too touchy about critiques of our code

2) tell your management how much disk space you need to run sql...

Excellent idea Leo !

When you run this:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

you get:

9.00.4262.00|SP3|Enterprise Edition (64-bit)

Even though the prod system shows as SP3, the queries below show something else for the resource database.

--To determine the version number of the Resource database, use:

SELECT SERVERPROPERTY('ResourceVersion');

GO

--To determine when...

The resource database for one of our SP3 boxes is dated 2008. For the one just upgraded to SP4 it shows last month, and for our main production system...

Would applying SP4 do the trick?

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=b953e84f-9307-405e-bceb-47bd345baece

It has login_name but not original_login_name which I believe came with SP2. Create date on our sys.dm_exec_sessions is 10/14/2005 Our resource database has that same date. It...

Very true.

The problem of complying with laws in multiple states reminds me of how the SEC and other regulatory bodies failed in regulating Wall Street. A domestic-only focus is...

Great checklist there Elliot. We do have change control. And annual SAS70 audits. It appears that many of the laws aren't actively enforced until you have a...

My company of about 350 employees is in California, USA. Our parent company is based in Connecticut. The company that just bought our parent and us is...