You bring up some good points Steve.

Perhaps the real answer to all this is to better partition our databases into multiple files?

In this way we cut down on the...

My experience is with good old PATA/SATA drives, so I can't comment on anything beefier.

I've tried using the built-in microsoft defragmenter, contig, Raxco PerfectDisk, Diskeeper, and most recently O&O Defrag....

emamet (5/13/2008)

---

Grasshoper,

Why did you need to use CLR integration?

Could not you have written a "simple" C# console application?

That can also run on the database server and could be more modular...

Or...

I'm not an expert DBA by any means, I know enough to be dangerous (which I'm sure you'll say the same about developers working with you as well :D).

In discussions...

Thanks,

luckily the nature of and the environment that our system runs in makes security more or less a non-issue. I'll take the example code from the article and see if...

Thank you for the quick reply, I don't think I was specific enough with my question however.

Let's assume that those queries are not contained in a stored procedure and are...

Great article.

Would we expect to see the same kinds of performance issues in frequently run queries that do not qualify the owner of the table?

E.g.

SELECT *

FROM table

WHERE...

I ended up finding a spare license for vs2005 lying about the office. The database project has let me stop pulling my hair out, thanks for your help everyone.

The one...

I'll see if we have an eval copy lying around, otherwise I'll try to get a hold of one. Thanks for the help.

Well I wasn't too crazy about that database workbench product. It did allow me to save procedures and functions as separate files rather easily, but it only supports it's proprietary...

Well I most definetely want to get out of the monolithic file.

I did stumble on a tool that may just help me do what I want (sort of),