Defaults are more efficient, but they don't provide a true audit trail as they are easily overriden by supplying values.  Triggers are harder to disable/override and so provide a more...

Good, glad I could help; but that doesn't explain why it was behaving differently on other servers.

How far off is it?  Do you have any specific examples?

Look at the execution plan to make sure that the query is using the index.

Is the volume compressed?

As long as you are in the sysadmin role, any objects you create will automatically be dbo unless you specify an owner.  You should always specify an owner, but very...

I had a similar problem a while ago and posted my findings.

HTH

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=19707

When you save the DTS package you can specify an owner password.  If you do this, even sysadmins won't be able to modify the package without it, but anyone who...

I'm not sure exactly what Noel was referring to but I assume it's something like creating a new table with the proper column lengths, import the data from the original...

alter table <TableName>

alter column <ColName> varchar(100)

Proc cache is limited to 2GB (on 32 bit machines).  The reason your cache hit ratio seems low is probably because you are looking at the "total" which is most...

In my earlier post I pointed out that this data is NOT in a "hidden table" that is not accessible to the user.  This information is in fact in sysproperties...

First off, thank you for the article.  It isn't very often that I get to read an article that really teaches me something new and explains something that has left...

I have worked with document management and image management software for a few years and all of the systems that I have seen suffer from the issues raised by EdVassie.  Some...

I've had this problem with a number of third-party applications over the years.  Generally it's because they expect their product to be the only database on your server and they...