Ha I got burned by the "Extents can be owned by only one object" as well on this. Looking at I think I read it as "Extents can be only...

Just to throw another one out there... If you are doing Eclipse/Java development BIRT is pretty nice...

http://en.wikipedia.org/wiki/BIRT_Project

We started a rewrite of a product a couple years back in Java and...

A simple bulk insert into SQL Server and then a SQL query would probably have been my approach but hey sounds like you did in a way that was fun...

We develop our databases like our code with everything scripted to build the database is in source control. We have a task in our build process that builds an empty...

Would this be a case when it would make sense to DISABLE an index before rebuilding it?

http://msdn.microsoft.com/en-us/library/ms177406.aspx

I've used this one before in some development testing but was curious it had...

So the clustered index bit of the question was just a decoy huh? Either way there will be 4 structures whether it is 4 heaps or 4 b-tree's right?

Did you try making your batch size smaller when loading up your data in the CLR and processing it? I could potentially see you running into memory issues causing disk...

+Infinity

Still even with obfuscation its still CLR which is going to be easier to backwards engineer than disassembling native machine code.

Putting stuff in CLR isn't going to help anything. I can extract an assembly out of a database and look at in Reflector and see what its doing in seconds.

If...

Jack Corbett (2/14/2011)

---

You should be a DBA :-D.

I agree with you that direct table access is evil. Most developers I have worked with or interact with now, will tell...

Have you read the Books Online Docs about bulk insert methods?

http://msdn.microsoft.com/en-us/library/ms187042.aspx

If you are wanting to bulk insert from a C# application this blog entry might help...

http://blogs.msdn.com/b/nikhilsi/archive/2008/06/11/bulk-insert-into-sql-from-c-app.aspx