As far as that setting, you'd need to do some testing to see what works better with your system. I'd test the performance of some procs with the settings at...

create view myview as select field1 from tableA

I assume you're using Text for the notes and some type of character field for the chapter.

If this is in Word, either write some parsing routine in VBScript/Vb.NET, C#, etc....

I think it's a wash as well, but you could argue that they do go in two different fields because you want to require them. The time wouldn't be required...

I tend to work as Patrick above, but if there is a shared server, usually developers don't have rights. Not to be a pain, but keep track of what's changed...

I do not believe that info messages are sent with this command. I tend to issue the shrink in small chunks in case I need to cancel it.

This could be the problem: http://support.microsoft.com/default.aspx?scid=kb;en-us;271223

Do you now have the ldf? Did you detach the db?

You can also try this: http://eai.ittoolbox.com/groups/groups.asp?v=SQL-SERVER-L&i=424438

I'd do a backup and restore to test. Then when you have it down, logins moved (search sp_help_revlogin), then do a full backup on source and move to produciton. Then...

As SQL needs memory, it will request more memory from the OS. You can use Enterprise Manager | Server | Properties | Memory tab and you can limit the maximum...

Been backing up for 10 years and never stopped a database for a backup yet. Restores work without a flaw.

The memory is released, but the caching might be affected. This will balance out as other queries are called. Right now I do not believe there is anyway to affect...

Yeah, I got one

The close wording is intentional. A view having 2 tables does not necessarily impact the ability to update. It could...

I completely agree with the business problem, which was why I provided a couple examples. If I have an OLTP system taking orders and one transaction, not one row, one...

Good suggestion. The question has been edited to reflect SQL 2000.

I'd start by listing the objects that you think you need to store. You need a customer, you need some type of rental agreement, some inventory, some cost structure.

If the...