In the original post, it's noted that there is a base table and 10 children. I'd bet there's a missing index on the foreign key of at least one...

Agreed. Make sure you have a PK on the table. If it were me, I would make an integer field as the primary key and add a unique...

Could you provide the DDL for the tables?

Personally, I like collecting this type of data all in one place. It allows me to run reports on a single table instead of having to hit tables in...

I think your first step should be to speak with your DBA.

First create physical tables to use for long-term tracking of the size info you want. Include a datetime column. You'll only do this once when you first set...

Without reading and testing each block, it looks like you've already done the real work. From here you have two choices:

1. When your script is done, insert the data...

I believe a .NET error screen does reveal too much. It shows that you're using .NET, which is easy. However, it can also reveal things you don't want...

That's not much to go on. Do you have any details of it? DDL? Insert statement?

I also agree with Anthony completely. When we upgraded from 2005 to 2008, we installed it on a separate physical server and tested everything. I will say it...

Not trying to be ignorant here, but if you don't have access to create databases on that server, then maybe you shouldn't be creating databases on that server. Instead,...

Agreed. Unfortunately, McAfee slows everything down.

I agree that granting sysadmin to extra users is a security concern that should be talked through. The alternatives I see are:

1. Have McAfee run as a Windows account...

set dateformat dmy;

select CONVERT(datetime, '31/12/2012 16:30');

Yes, that's how foreign keys work. You have a foreign key in a child table that references that references a primary key in the parent table.

If you're creating an...